Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
add same expression in script and name the field, u can take the sum in measure