Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Variable not working as expected in Set

Hi All,

I am trying to use the following function:

sum({<weekago={'>52<$(52+$(NumOfWeeks))'}, MONTH_DESC>}CURRENT_SALES)

I want to sum the sales of for weeks in previous year to date time period.

The NumOfWeeks variable is defined as

max({$<YEARAGO={'<1'}, MONTH_DESC>} WEEKAGO)

0 Replies