Forum Discussion

Fusilier2's avatar
Fusilier2
Icon for Helper V rankHelper V
10 months ago

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     ...
Need Help
Fusilier2's avatar
Fusilier2
Icon for Helper V rankHelper V
10 months ago

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.