Skip to Content
0
Aug 10, 2016 at 11:13 PM

Positive and Negative Amounts are netting

33 Views

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

Attachments

Untitled.png (10.7 kB)