Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
wenjun2016
Contributor II
Contributor II

Add values from two different columns in expression

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.


1 Reply
vinay_hg
Creator III
Creator III

add same expression in script and name the field, u can take the sum in measure