topic vSetWeeklyPrev doesn't work in Management & Governance

vSetWeeklyPrev doesn't work

zied_ahmed1 — Fri, 07 Apr 2017 10:11:08 GMT

Hello I have this variable :

vSetWeeklyPrev :

[Calendar date]=, [%Year week SEQ]={$(=max([%Year week SEQ])-$1)}, [%Date ID] = { "<= $(=max([%Date ID]) -7)"}

it doesn't work

On the another hand

the vSetWeeklyPres work :

[Calendar date]=, [%Year week SEQ]={$(=max([%Year week SEQ]))}, [%Date ID] = { "<= $(=max([%Date ID]))"}

What's the problem with the vSetWeeklyPrev ?

Thank you

Regards

Zied

Re: vSetWeeklyPrev doesn't work

jpar0511 — Fri, 07 Apr 2017 10:41:00 GMT

Just a suggestion:

[Calendar date]=, [%Year week SEQ]={$(=max([%Year week SEQ])-1)}, [%Date ID] = { "<= $(=max([%Date ID]) -7)"}

Re: vSetWeeklyPrev doesn't work

zied_ahmed1 — Fri, 07 Apr 2017 10:49:37 GMT

thanks for your answer, my expression when i don't select any week of date the Prev works,so i would like when i choose a week of date for example week of date 3 of April the prev display the value for week of date 2