Hello - wondering what is the best way to get this single table to show the different value formats I need. Hoping to get dollar values (gross payroll, indirect payroll, etc.) to show zero decimals and then convert NOO% and Net Margin % to percentages. Currently have the table tool displaying 2 decimals in the value column and is why ER is correct, just need to figure out how to change the others individually.
Solved! Go to Solution.
Something like this?
IF Contains([Name],"%") OR Contains([Name],"Ratio") THEN ToString([Value],2)
ELSE ToString([Value],0,1) ENDIF
Getting closer, how can I get the NOO% and Net Margin % to show as 134% and -19%?
Think I answered my own question, formula/screenshots below. Really appreciate the help.
IF Contains([Name],"%") THEN ToString([Value]*100,1)+"%" elseif Contains([Name],"Ratio") THEN ToString([Value],2)
ELSE ToString([Value],0,1) ENDIF