Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Custom income statement visual not displaying when adding Format statement

I have created a custom income statement and everything is working fine except for the three calculations that are percentages instead of dollars.  The measure is formatted as percentage, but it's showing as dollars still.  When I try adding a Format ([Bal_GrossMargin],"0.0%"), statement, the visual stops displaying any data and says "Couldn't load the data for this visual."

 

Please see image of the measure and below that the overall measure for all of the lines.

(I currently am multiplying by 100 to at least get the percentage to show something)

9 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    using FORMAT converts the value to text. You would need to apply FORMAT to all your SWITCH choices.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      When I do this format shown below, it works fine.  But the red highlighted boxes should be formatted "0.0%" and when I do that, it causes the visual to stop displaying.

       

      • lbendlin's avatar
        lbendlin
        Super User
        2 years ago

        looks like your locale needs this to be "0,0%"  ?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Ok, I tried that: see results.

    It looks like once I change a single format to %, it fails.