7 Replies Latest reply: Oct 12, 2015 10:30 AM by Mark Graham RSS

    Filtering with generic If Statement

    Mark Graham

      Hi all,

       

      I have 4 fields Class1, Class2, Class3, and Class4 with ID.

       

      I want to filter into 3 buckets based on their values.

       

      If Class1 or Class2 or Class3 or Class4 if greater than 30, then ID as 30+ID,

      similarly for other numeric values like 59, 100 etc..

       

      But the if statement i use is not accurate enough and giving all the IDs as result.

       

      Can someone pls look here.

      It will be a great help.