Skip to Content

Need to add amounts on Condition

Hi Experts,

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

Add comment
10|10000 characters needed characters exceeded

  • 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.

  • Get RSS Feed

3 Answers

  • May 02, 2017 at 10:23 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • May 02, 2017 at 10:32 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • May 02, 2017 at 10:35 AM

    Just to add the below is the desired output ::

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

    Add comment
    10|10000 characters needed characters exceeded