Hi,
I have a report which shows, Beginning Balance, Additions and Deletions. All the amounts are displaying correctly except when there is a positive and negative amounts for same Document Code (But different document ids). the reports should display all the +ve amounts in additions column and -ve amounts in deletions column.
Report should display as follows based on the values from the below screenshot
Additions Deletions
2,103,498.92 (1,249,182.64)
But the report is netting the values as follows
Additions Deletions
854316.28 (102908.46)
Formula for Additions:
=[ Doc Total Amt] Where ([ Doc Code] = "FA" ) + [ Doc Total Amt] Where ([ Doc Code] = "FI" And [ Doc Total Amt]>0 ForEach([FA Component No]))+ ([ Doc Total Amt] Where ([ Doc Code] = "FX" And [ Doc Total Amt]>0 )- [ Doc Total Amt] Where ([ Doc Code] ="FC" ))
Thanks,
Arvind