cancel
Showing results for 
Search instead for 
Did you mean: 

How to calculate the monthly total from week based model using advanced formula

raj_trivedi
Explorer
0 Kudos

Hi All,

I am trying to calculate the total cost of a month where the base data in the planning model is at a weekly level. I need it as part of the calculation in Advanced Formula. Please suggest if you have done something similar where you aggregated values of base members into a variable.

Source

raj_trivedi_0-1711639705072.png

Expected Value:

raj_trivedi_1-1711639776458.png

Thank you in advance.

Accepted Solutions (0)

Answers (0)