Skip to Content
0
Aug 15, 2023 at 09:22 PM

SAC - Dividing by number of day by month

92 Views Last edit Aug 15, 2023 at 09:23 PM 2 rev

Hi

I have a monthly granularity model.

for one of my calculations I need to multiply a fix parameter/cost with the number of day of every month.
(my date memberset, is a full budget year)

Of course, I don't want to maintain manually the number of days as a measure/account.

Is there a way to use an integer or something like that to write down:

DATA (monthly cost)=RESULTLOOKUP(Number of days)*RESULTLOOKUP(Daily Cost)?

Thank you !!!

image.png

Attachments

image.png (19.4 kB)