Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=sum({<([Year Week] = {'=$( =year(today()) & Week(today()-7)'>} Sales)
Note: added '=' sign and removed comma at the end.
Update: Remove the '(' in red.
=sum({<([Year Week] = {'=$( =year(today()) & Week(today()-7)'>} Sales)
Note: added '=' sign and removed comma at the end.
Update: Remove the '(' in red.
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