6 Replies Latest reply: Jul 5, 2017 8:46 AM by Luis Rodríguez RSS

    How make a data range for a calculated measure field?

    Luis Rodríguez

      Hi there!

       

      I have a doubt, I Have a table with 4 fields, all are from the original table.

       

      | Product | Region | Sum of Product | Sum for Total Region |

       

      In addition of this, I made a calculated measure field in which I'm calculating a percentage from the [ Sum for Total Region ] with the next function:

       

      calculated measure field [% From Total] =  [ Sum of Product ] / [ Sum for Total Region ] = % from the Sum for Total Region

       

      Then I have my table with 4 original fields and 1 as a calculated measure:

       

      | Product | Region | Sum of Product | Sum for Total Region | % From Total |

       

      My doubt is: How could I make a new field [ Class ] to get a classification from my calculate measure field as such as I want:

       

      | % From Total | Class |

       

      If the result in the camp % From Total >= 0% and <=40% then is Bad

      If the result in the camp % From Total >= 41% and <=70% then is Regular

      If the result in the camp % From Total >= 71% and <=100% then is Good

       

      For Example:

       

      | % From Total | Class   |

      |          52.48%  | Regular |

      |          79.99%  | Good    |

      ....


      I hope you could help me.


      Greetings


      Luis