How To Write An Allocation To Get The Difference In Two Sets Of Data In Ledger_Stat (Doc ID 283178.1)

Last updated on FEBRUARY 17, 2020

Applies to:

Goal

For data in LEDGER_STAT table, you want an allocation which finds the difference between the sum of four lines, and the sum of three other lines (delineated by combination of leaves). For example, you would like to see the following:

FE            ORG          COMMON            AMOUNT
100          1001          302145             $100
100          1002          302145             $200
100          1003          302145             $300
100          1004          302145             $350

SUM = $950

FE           ORG           COMMON       AMOUNT
100          1001          302155       $ 50
100          1002          302155       $100
100          1003          302155       $400

SUM = $550

OUTPUT:  
FE              ORG         COMMON         AMOUNT
15005          9999         302155         $400

Solution