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
