Feb 16, 2022 02:07 AM
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
Solved! Go to Solution.
Feb 16, 2022 09:23 AM
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},',.*',""))
Feb 16, 2022 03:59 AM
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
Feb 16, 2022 09:23 AM
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},',.*',""))
Feb 16, 2022 06:08 PM
Yes, and downstairs came up with a solution. Thank you
Feb 16, 2022 06:11 PM
This is exactly what I need. Thank you very much