1 Reply Latest reply: Jan 12, 2017 4:35 AM by vinaykumar HG RSS

    Add values from two different columns in expression

    Wenjun Wu



      I need to create a dimension using expression.

      Below is part of my condition,


      if([Premise Type]='03' or [Premise Type]='04' or [Premise Type]='05' or [Premise Type]='EE', if(Matched = 1, (Value1+Value2), Value2), 0))

      I need to have the sum of Value1 and Value2, they are two data fields(columns).

      What is the expression syntax to add them up?

      Thank you.