That is weird! My first reaction was that you need to aggregate prior to taking the difference, that can be a problem with quotients for example because (a+b)/(c+d) isn't the same as (a/c)+(b/d) but for subtraction it shouldn't matter (a+b)-(c+d)=(a-c)+(b-d). That said, the int() function complicates things, since you're truncating all values to integers prior to aggregation it could be that subtraction will lead to confusing results. Still, it seems further off than I would expect from that alone, but I don't know your data if there are a lot of small values it could be the explanation.
Try changing the calculation to:
int(sum([Revenues Actual])-sum([Revenues Budget]))
or just leave off the int entirely.
Thanks a lot.. it worked ...
Wow! That is a pretty extreme case of rounding error. Must be a pretty big dataset. I guess you'll need to be careful with rounding.
Despite my surprise, I'm glad that worked. If it was an SAP thing I wouldn't have had a clue.
Ya.. Even I am surprised that it worked so easily.. thanks for the help