Add values from two different columns in expression

wenjun2016 — Thu, 12 Jan 2017 09:23:49 GMT

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.

Re: Add values from two different columns in expression

vinay_hg — Thu, 12 Jan 2017 09:35:20 GMT

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