LEN formula to currency

Hello,

Is this article helpful?

Solved: Re: Remove from position - Airtable Community

Hm, do you mean like with a "$" or some such currency symbol?  Would formatting the field help?

Hi @Julien_Etoke,

You can adjust the formatting of a formula field to display a currency symbol of your choice:

Hope that helps!
-Stephen

Hello!

I tried your differents solutions/ideas but I get an error. I will explain more precisely the idea :

Field 1 - "Sales" - (text) : Getting sales list from Systeme.io with too many "0", like that "16000" instead of "160"
Field 2 - "Sales without 0" - (formula) LEFT(Sales,LEN(Sales) - 2 : To delete the "00"
Field 3 - "Sales with currency" (formula) : I am trying to get the sales prices with currency to be able to summarize it in a second time.

On my field 3, I tried "FLOOR({Montant clarifié}/100,1)"

Any idea ? 🙂

Hi @Julien_Etoke,

Have you tried the formula field’s formatting settings in the screenshot I posted earlier? You can make the output of your formula fields display as currency this way. Please let me know if it doesn’t work.

-Stephen

Hello!

I created a new table to to clarify :

I'm looking to get this result : 200 €

I tried this formula "FLOOR({field_name}/100,1)" on the field "Price + €" but I get an error 🙂

FLOOR is unnecessary as you mentioned the last 2 digits in the original value represented cents and then you removed them which would give you whole numbers as currency and disregard the cents. In field 3, why are you dividing by 100? To output in currency format, please see my previous comments.

I can't output with currency and I think i'm really lost to get what I am lookinf for 😃

Strings and numeric values are different things to a computer
To use a currency format, it must be numeric

Use the VALUE(string) function to force the conversion of strings to numeric values for calculations

It works !! Thank you !