3 Replies Latest reply: Dec 23, 2015 12:44 PM by Sunny Talwar RSS

    Multiple if in straight table expression

      =sum(If([Descriptive Analysis Response]='Beginner',2,0))or

      if([Descriptive Analysis Response]='Applying',3,0)or

      if([Descriptive Analysis Response]='Expert',5,0)

       

       

      Actually i have survey responses like beginner, expert etc, for each questions.

       

      I want to sum up the response and give a weighted total.

       

      =sum(If([Descriptive Analysis Response]='Beginner',2,0)) this one works but rest of the if statement not working


      Please help