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

4 votes

New · Last Updated

Get Started with Idea Exchange

See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!