Haven’t we run into this case? I’d say occasionally for me. Cause I mostly change the data type to Int and then format it from here Scenario:
While switching between the below 3 metrics change the display to match. Which meant the common data type to handle the 3 metrics is str . Sales — $xx,yxy Profit Ratio — xy.yx% Items per Order — xx.x Data set: Super Store Formulas : Sales
“$”+REGEXP_REPLACE(STR(round(sum([Sales]))),”(\d)(?=(\d{3}))”,”$0,”)
