Different value formats on same table

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.

Developer

Developer Tools

Accepted answers

Christina_H

Something like this?

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

All comments

Christina_H

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703