Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Formatting Measure Results Depending Upon Calculation Type.

Hi, I am trying to create an income statement with numbers to be formatted as numbers and percents based as percents.  The calculations work fine but I can't seem to take the % Sales as a Percent an...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Never mind, I figured it out.  Use 

    MAXITEM2=17,FORMAT([Actual % Sales],"Percent"),  instead of calculating the value and then attaching the format.