Derivative rule based on time

Jacob
New Contributor

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?

Jacob_0-1678211959489.png

 

1 REPLY 1

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

Factor.png

NicolasArgente_0-1678265335989.png

 

Please give a Kudo if it helps

Connect with me on:
LinkedIn: https://www.linkedin.com/in/nicolas-argente/
Website: https://aiqos.io
If you want to lift yourself up, lift up someone else.