Forum Discussion

Christoph's avatar
Christoph
New Contributor
3 days ago

Write an amount

I am having difficulty writing an amount to a prior month via a Finance business rule.  Specifically, for forecasting purposes in the last month of a quarter we calculate an excess amount and then want to spread that amount to the last two months in the quarter.  I can successfully calculate and write to the last month but cannot seem to write to the prior month.  For example, in Q2 as of June calculate the excess amount and then write 50% in May and 50% in June.  Has anyone been able to accomplish something like this?  Thanks in advance. 

Finance
  • markolainio's avatar
    markolainio
    New Contributor II
    2 days ago

    Time is a data unit dimension and as the calculations run per data units as a default you cannot and should not write outside of the current data unit. However, you can retrieve values from outside of the current data unit. So, I think you could first calculate the value you want to spread to the future month and then you would need to run calculations for the prior months to retrieve the calculation outcome to the prior months. This could be done with custom calculate for example.

    Hopefully this answered you question.