Forum Discussion
Help with dynamic format strings
Hope somebody can point me in the right direction regarding dynamic formatting. I have this table: Period KPI Code KPI value Data Type Jun-24 PC008 2.12 Number ...
I've had a look at the article but I can't work out if it is possible to add in an IF statement for the format.
For example
IF(DataType = "Percentage", "0.0%",
IF(DateType = "Number", "0.0"
Or similar.
