2 Replies Latest reply on Jul 12, 2017 7:19 PM by arvindgarg

    Ignore using multiple parameters for multiple calculations

    Ravi Teja Jagarapu
      AEntered by userValue 1
      BEntered by userValue 2
      CEntered by userValue 3
      DEntered by userValue 4




      I am trying to understand if we can ignore using multiple parameters for one of my requirements. For each measure in table above, user can enter a score between 1 to 100. Based on the score entered by the user, I need to calculate the rating for each measure and the calculation differs for each measure. (For ex: For measure A, if score is between 0-10, rating is 1, if score is between 10-20 rating is 2 whereas for Measure B, if score is between 0-11.5, rating is 1, if score is between 11.5 to 23 rating is 2 and so on). I want to know if there is a way to approach this problem without creating parameters for each measure separately.