The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

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
NicolasArgente's avatar
NicolasArgente
Valued Contributor
4 years ago

Hi SC,

There are many ways to do that but to stick to your method can you try it like this :

You do
A#SwapProd = A#SwapProd_New and multiply by 1
Then after you add a rule a bit like you did above that says
A#SwapProd_New = A#SwapProd_P If positif
A#SwapProd_New = A#SwapProd_N If Negative
Can your try?
Please give a thumbs up if it helps.
Nic