Forum Discussion

SC's avatar
SC
New Contributor III
4 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
SC's avatar
SC
New Contributor III
4 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
    4 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