12 Replies Latest reply on Aug 19, 2016 11:22 PM by Suresh

    Required "Values between" Formula Calculation

    Suresh

      Hi everyone,

       

      Good day all!

       

      I required a small clarification. Have some values & need to apply a concept.

       

      If my Value(Score) <= 85 means set Field1's input as 1

      85 < Value > 95 means 2

      95 < Value > 100 means 3

      100 < Value > 110 means 4

      110 < means 5

       

      So I use case function,

      Here my calculation.

      Case ( Score ≤ 85; 1; 85 ≤ Score ≥ 95; 2; 95 ≤ Score ≥ 100; 3; 100 ≤ Score ≥ 110; 4; Score ≥ 110; 5)

       

      But I feel Result is coming wrongly, somewhere i did mistake!

       

      Please suggest me where i did mistake!!

       

      Suggestions & Solutions much appreciated!

       

      - Suresh