Skip to main content
Best answer

Reduce number of decimal places using formatter

  • August 20, 2020
  • 4 replies
  • 1964 views

I’m using formatter to get line items from Xero, and create a trello card using those line items. 
When converting the line item quantity to a string, it returns the quantity with four decimal places ‘1.0000’. 

How can I reduce the number of decimal place, to show only an whole number ‘1’? 

Thank you in advance!

Best answer by WemakefutureBest answer by Wemakefuture

you can use python:


yourstring.split(",")[0]

 

Or try formater

https://zapier.com/help/doc/how-use-formatter-functions

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Wemakefuture
Forum|alt.badge.img+8
  • Zapier Expert
  • 166 replies
  • Answer
  • August 21, 2020

you can use python:


yourstring.split(",")[0]

 

Or try formater

https://zapier.com/help/doc/how-use-formatter-functions


tweiland wrote:

you can use python:


yourstring.split(",")[0]

 

Or try formater

https://zapier.com/help/doc/how-use-formatter-functions

Yes


  • Author
  • Beginner
  • 1 reply
  • August 23, 2020

thank you for your help - I have it running now with ‘Customize Numbers’ and a spreadsheet formula using Formatter!


Wemakefuture
Forum|alt.badge.img+8
  • Zapier Expert
  • 166 replies
  • August 24, 2020
Haydn wrote:

thank you for your help - I have it running now with ‘Customize Numbers’ and a spreadsheet formula using Formatter!

Yeah defently a way to go :)