Skip to main content
J
Jacob
March 7, 2023

Derivative rule based on time

  • March 7, 2023
  • 2 replies
  • 0 views

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

 

2 replies

N
NicolasArgente
March 8, 2023

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

G
gbftong
May 21, 2025

Thanks this was a helpful example!!

Terms & ConditionsAccessibility statement