Skip to main content
Best answer

Reduce number of decimal places using formatter

  • August 20, 2020
  • 4 replies
  • 2145 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 Wemakefuture

you can use python:


yourstring.split(",")[0]

 

Or try formater

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

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 Solution Partner
  • Answer
  • August 21, 2020

you can use python:


yourstring.split(",")[0]

 

Or try formater

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


you can use python:


yourstring.split(",")[0]

 

Or try formater

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

Yes


  • Author
  • Beginner
  • 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 Solution Partner
  • August 24, 2020

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 :)