Hello
I need to calculate sum of a table and if the sum of each line with the same CALLER is more then 2000 then add up all the fields that are over 2000 and do some more calculations.
the expression seems to work in a pivott table and i get the fields that are over 2000 but the expression seems to get the wrong numbers in a text field.
the expression look like this
if(Sum(EKS) *-1 - sum(VARE)>2000, ((Sum(EKS) *-1 - sum(VARE) - (NumericCount (DISTINCT CALLER) * [KR])) *0.05))
if i add the values up manualy from the piviott i get 1669 but the text field gets 2033
table look something like this
CALLER | desc | EKS | VARE |
---|
900 | blablabla 234 | 100 | 95 |
900 | blablabla 23423 | 120 | 100 |
905 | blablabla 23423 | 234 | 12 |
905 | blablabla 236 | 444 | 333 |
905 | blablabla 373 | 12 | 1 |
952 | blablabla 23778 | 22 | 11 |
any ideas?