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

    Add values from two different columns in expression

    Wenjun Wu

      Hi,

       

      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.