Need to add amounts on Condition

[sachin_v_joshi]

Hi Experts,

I have a BO Report giving me results of Credit and Debit of amounts for various gl accounts

[sachin_v_joshi]

Below is the ref data

We are not showing the Debit _credit column in the report

GL AccountExportTax AmountNet Accumulated AmountGross AmountPeriod(Month)Legacy File NumberSource System179057Y3329380,19201703140RFBACC297903Y-3329380,19201703140RFBACC605024Y360185,98201703140RFBACC299957Y-360185,98201703140RFBACC

but my requirement is to show the Net Accumulated amount which would be

as below

Debit CreditTax AmountGross AmountNet AccumulatedD3689566,17C-3689566,17

I tried using FORALL functions but could not get closer to the desired result.

Any help would be appreciated.

[sachin_v_joshi]

Just to add the below is the desired output ::

Debit Credit Net Accumulated
D 3689566,17
C -3689566,17

[sachin_v_joshi]

Amit, I had tried that only but the result is not as per expectation.

I'm giving sample data below

GL_Account Export Net Accumulated Amount Period(Month) File_Nbr Source
179057 Y 3329380,19 201703 140 RFBACC
297903 Y -3329380,19 201703 140 RFBACC
605024 Y 360185,98 201703 140 RFBACC
299957 Y -360185,98 201703 140 RFBACC

Now when we have 2 negative figures they represent D while positive amount stands for Credit

These 2 amnounts need to be shown explicity on the fly in Report.We are on

SAP BusinessObjects BI Platform 4.1 Support Pack 5 Patch 7

[amitrathi239]

if you are not showing Debit _credit column in the report then you need to use Foreach in the formula for calculaiton.