Help

Discover what data silos are costing your org in our commissioned Forrester study. Learn more

How can the final result of the formula be converted to a numeric value with 2 decimal places

Topic Labels: Formulas
Solved
Jump to Solution
484 4
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi
Can airtable fulfill my requirement? Please see the picture for specific examples. I need to reserve two decimal digits in the column of “Original Price” in the picture
ask

1 Solution

Accepted Solutions
Andy_Lin1
8 - Airtable Astronomer
8 - Airtable Astronomer

Since your formula outputs a string, you need to convert it to a value first (see below) and then you’ll be able to use the Formatting tab to set the number of decimal places.

VALUE(REGEX_REPLACE({T. price Rollup},',.*',""))

See Solution in Thread

4 Replies 4

Hey @Vijay_chen,

your roll up field “T. Price Rollup” returns a list of values that are separated with comma and dot are the symbol for the decimal numbers. In your formula as I guess you try to replace all those symbols right and create a consequence of all those values in text. Is that right?

Thanks

Andy_Lin1
8 - Airtable Astronomer
8 - Airtable Astronomer

Since your formula outputs a string, you need to convert it to a value first (see below) and then you’ll be able to use the Formatting tab to set the number of decimal places.

VALUE(REGEX_REPLACE({T. price Rollup},',.*',""))

Yes, and downstairs came up with a solution. Thank you

This is exactly what I need. Thank you very much