Forum Discussion

SC's avatar
SC
New Contributor III
3 years ago

Derivative rules

Hi experts,   I have a group of GL accounts that I need to map to either an expense / revenue based on the sum of the balances. I thought this would be easy enough with a derivative rule; first cr...
Data Integration
Transformation
  • Sai_Maganti's avatar
    Sai_Maganti
    3 years ago

    My guess is that, in order for the first line in your DR to create an aggregation you must use all the dimensions including any attribute dimensions similar to this:

    E#[*]=All_Entities:F#[*]=All_Flow:IC#[*]=All_IC:UD1#[*]=All_UD1:UD2#[*]=All_UD2........:A1#[*]=All_A1:A2#[*]=All_A2......

    This will then create a one line sum for all your specified accounts and assign that sum to A#[Map_SwapProd] and then the next 2 rules should work fine.

SC's avatar
SC
New Contributor III
3 years ago

Thanks for your response Nic. So, you are saying I can't get this working through a >x  and <x operator, but I actually have to write a rule for this?

Regards,

S

  • NicolasArgente's avatar
    NicolasArgente
    Valued Contributor
    3 years ago

    You need one rule that adds them up. It is the first one with NEW in the name
    Then according to the total of the NEW you will know the sign