Skip to main content
Solved

Applying a specific months value to all months in a year

  • February 14, 2024
  • 1 reply
  • 254 views

Forum|alt.badge.img

Hey,

I am trying to reference the headcount for December and apply it to all months in the relevant financial year as part of a calculation. i.e if head count in Dec 24 in 100 and Dec 25 is 150, the formula would show 100 for all months in 2024 and 150 in all months of 2025.

Has anyone done anything like this before and found a solution?

 

Thanks!

 

Best answer by francois

Hi!

You should be able to do this by chaining two BY:

 

By typing Value[BY SUM: Month.Year][BY CONSTANT: Month.Year], you first apply the Dec value to the corresponding year (100 in Dec 22 → 100 in FY22) then reapply the yearly value on every month of the year (100 in FY22 → 100 on all months of FY22)

Have a try in the formula playground! I encourage you to try and type:

  • Value
  • Value[BY SUM: Month.Year]
  • Value[BY SUM: Month.Year][BY CONSTANT: Month.Year]

Hope this helps!

View original
Did this topic help you find an answer to your question?

francois
Employee
Forum|alt.badge.img+13
  • Employee
  • February 14, 2024

Hi!

You should be able to do this by chaining two BY:

 

By typing Value[BY SUM: Month.Year][BY CONSTANT: Month.Year], you first apply the Dec value to the corresponding year (100 in Dec 22 → 100 in FY22) then reapply the yearly value on every month of the year (100 in FY22 → 100 on all months of FY22)

Have a try in the formula playground! I encourage you to try and type:

  • Value
  • Value[BY SUM: Month.Year]
  • Value[BY SUM: Month.Year][BY CONSTANT: Month.Year]

Hope this helps!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings