cancel
Showing results for 
Search instead for 
Did you mean: 

SAC Advanced Formula - Copy month value to all months of specific year

mfrieser
Participant
0 Kudos
383

Hello,

the requirement is rather simple, but i am not yet very experience in advanced formulas.

I want to select a month of a specific year (defined as dynamic parameter) and then select a year (or year as the node of a date hierarchy). 

Then this monthly value should be copied to every month of the selected year. 

How is this possible with advanced formula?

Thank you!

View Entire Topic
mfrieser
Participant

I just figured it out myself, this is the code:

MEMBERSET [d/Measures] = "VALUE_PROJECT"

MEMBERSET [d/Date] = BASEMEMBER([d/Date].[h/YM], %TARGET_YEAR%)

DATA()=RESULTLOOKUP ( [d/Date] = %SOURCE_MONTH%)

 

 

N1kh1l
Active Contributor
0 Kudos
mfrieser, Thats perfect.