set analysis syntax

[#1]

Hi!

is there anyway to rewrite the following to be included in set analysis

sum (if([Year Week] = year(today()) & Week(today()-7),

Sales)

i have tried the following without success

sum({<([Year Week] = {'=$(year(today()) & Week(today()-7)'>},

Sales)

Best

Brad

[tresesco · Accepted solution]

=sum({<([Year Week] = {'=$( =year(today()) & Week(today()-7)'>} Sales)

Note: added '=' sign and removed comma at the end.

Update: Remove the '(' in red.

[avinashelite]

Hi Bradley,

Please create a variable to store the current year i.e. year(today())

You cannot use & here, use comma which will act as and function.

and use this variable in the set analysis like below:

sum({<([Year Week] = {'=$(variable) , Week(today()-7)'>}Sales)

Regards,

@vi