cancel
Showing results for 
Search instead for 
Did you mean: 

Date in data action script

0 Kudos
269

Hello community,

I want to use a date parameter to choose the year and then run my script on this year, how I can use it please?

2022-12-02-16-09-15-sap-analytics-cloud-et-4-pages.png

Thanks in advance for advising.

View Entire Topic
William_Yu
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi betarek,

You can just put %year% into MEMBERSET section with BASEMEMBER and reomve it from DATA() and RESULTLOOKUP().

I would also suggest you to check the help page of advance formula.

Best regards, William

0 Kudos

Thank you,

I used the memeberset but I can’t choose just the year, you have to choose the month too

what I want is to choose only one year

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

DATA([d/Account]="vente")=RESULTLOOKUP([d/Account]="qte")*RESULTLOOKUP([d/Account]="PriceList")

William_Yu
Product and Topic Expert
Product and Topic Expert
0 Kudos

It's true that you can't restrict user 'can only' select at year level. But it's possible for user to 'only select' one year. User can just select from year level, not expanding hierarchy.