Forum Discussion

Jacob's avatar
Jacob
New Contributor
3 years ago

Derivative rule based on time

Hello all,

I am looking to spread budget data across 12 months evenly, however my source is only designated one time.

I am looking to split time into all twelve months of the year and divide the amounts accordingly. Is this possible?

 

  • NicolasArgente's avatar
    NicolasArgente
    Valued Contributor

    Hey Jacob!
    Did you have a look at the factor value in the DataSource. You could use that to multiply by 0.08333333333 (wich is divide by 12).
    The other alternative is a complex expression in your amount with something like Return arg.value * 0.08333333333.
    I did not try any of those solution, but it should work

     

    Please give a Kudo if it helps