Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
exp1= if([Customer Number Act]='789QWA','DIR',
exp 2 = if([Customer Number]='9977YU','COMM', null()))
now i need to add these two exp and name it as total
and this total should show me the values of exp1+exp2
for example exp1=23 and exp2= 46
this one i will be using in the script
then total = 69
Can you provide some more detail on what you want with some sample data?
Can you try using doller sign expression?
eg =Sum(exp1+exp2)
You can add both expressions directly
Expression_1 + Expression_2
You will get sum of those two Expressions.
Eg: If([Customer Number Act]=................) + If([Customer Number]=..................)
23 + 46
So the result will be 69.