Best answer

Reduce number of decimal places using formatter

  • 21 August 2020
  • 4 replies
  • 558 views

Userlevel 1

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!

icon

Best answer by Wemakefuture 21 August 2020, 16:28

View original

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

Userlevel 6
Badge +7

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

Userlevel 1

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

you can use python:


yourstring.split(",")[0]

 

Or try formater

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

Yes

Userlevel 6
Badge +7

you can use python:


yourstring.split(",")[0]

 

Or try formater

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