Different value formats on same table

[dottman]

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.

[Christina_H · Accepted solution]

Something like this?

IF Contains([Name],"%") OR Contains([Name],"Ratio") THEN ToString([Value],2)
ELSE ToString([Value],0,1) ENDIF

[dottman]

Getting closer, how can I get the NOO% and Net Margin % to show as 134% and -19%?

[dottman]

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