Skip to main content

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!

you can use python:


yourstring.split(",")[0]

 

Or try formater

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


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


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


you can use python:


yourstring.split(",")[0]

 

Or try formater

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

Yes