Pivot Table Total Problem

[#1]

I have a pivot table with a few dimensions and one expression. The expression is something like:

if(field = 'R',-Sum(sales),Sum(Sales))

The detail in the pivot table show the negative numbers properly. However the "Total" amount in the pivot table is not taking into account that some amounts are negative and is showing the total as if all number are a positive number.

Any Ideas what is wrong?

Thanks,
Stephen

[hector]

Hi, I dont know, but the resident should be from SalesDocItem_temp or not?

c ya

[#3]

Yes, I changed it and am still getting an error. I'll keep looking at.

[hector]

the same error about noconcatenate?

[#5]

No, different error, but I got the script to work and unfortunately it did not fix the problem.