Forum Discussion

MK's avatar
MK
New Contributor II
2 years ago

Get Prior period value using derivative rules

Hi, I am trying to load data from file where amount should be calculated as prior period minus current period and loaded. I tried using derivative rule to setup current period equal to prior period...
Data Integration
MarcusH's avatar
MarcusH
Contributor III
2 years ago

I think you will need to use a BR to get the prior period's amount. Change the Logical Operator setting to Business Rule and that should allow you to get the previous value. You will need to make sure that there is only one source record for the target value.

  • MK's avatar
    MK
    New Contributor II
    2 years ago

    Thank you for the update.

    Can you please provide the example how I can get prior month value using business rule?

    Thanks,

    Manju Komara