Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How can I replace expression below with set analysis?
if(Field1=Field2, 0, Sum(Value))
I tried different variants. For example this one doesn't work as well.
Sum({$<Field1-=Field2>} Value)
FYI - I don't prefer to use direct set analysis. Because, Recently i had faced and took big challenge when this project on live. When i use that expression i am getting triple of the records like if i have script used like i mentioned it showing as expected but when i use Set analysis direct it consume triple like 3x. I wonder, That time that is cause some triggering issue i feel. Any how - You got the output. That's good ![]()