SUM formula returning negative currency values - w...

[Julien_Etoke]

Hello!

I automatically retrieve a list of sales directly in Airtable via Zapier, problematic, the price is sent "raw" from zapier with a lot of "0", like that : 16000 for 160

So I created a formula to remove them :

LEFT(raw_price, LEN(raw_price) - 2) 

And it works 🙂

Now, I am looking to create a new formula, in a new field to get the currency and be able to add the sales.

Any idea ? 🙂

[Stephen_Orr1 · Accepted solution]

Ah good catch @Sho. 

@Julien_Etoke change the formula to

VALUE(LEFT(raw_price, LEN(raw_price) - 2))

to convert it to a number so that the currency option appears 😄

[Julien_Etoke]

It works !! Thank you !