Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We have one calcuated field in the script which is something like this SUM(Field1*Field2) as NewField. When we use this inside the expression which is something like SUM(Field1*Field2). We are not get the expected output. We are expecting the same value what when we do at the script level. But both the data varies.
Can some one help me on this?
Try with this
SUM(Field1) * Sum(Field2)