FORMAT Function - Control how values are converted to text and displayed in the grid

0 Kudos

FORMAT Function - Control how values are converted to text and displayed in the grid

It would be useful to have a format function for converting values to text that worked in a similar way to the TEXT function in Excel.

 

The Function would be FORMAT(Value,"How to Format","Alignment")

e.g Value is 1000.0002 and when converted to text the decimals should not be displayed and left-align the result

FORMAT(Value,"#,##0","L") = 1,000

 

eg Value is 0.10234 and when converted to text it should be displayed as a % with 1 decimal place and right-align the result

FORMAT(value,"0.0%,"R") = 10.2%

 

Dashboards and Visualization

Calculation Functions

New UX