expression if equation > then sum

[#1]

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?