Forum Discussion

kfschaefer's avatar
kfschaefer
Helper IV
8 years ago
Solved

Format a calculated field as Percent

I need to modify the following to get it to display a kpi value as a percentage.  What do I need to change the format?

 

AvgTTD75% = DIVIDE(
SUM('IncidentTrends_Metrics'[TTD Met the 75%tile]),
SUM('IncidentTrends_Metrics'[Total Incidents])
)

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hey kfschaefer

     

    You just need to click on your calculated field and then go to the Modelling tab and click the % sign.

     

    Hope this helps,

    Parker

    • kfschaefer's avatar
      kfschaefer
      Helper IV
      8 years ago

      nevermind I figured it out.  thanks

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Awesome, please accept a reponse as a solution or post your own and select that one. Thanks!