Date in data action script

[former_member802420]

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.

[William_Yu]

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

[former_member802420]

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]

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.