Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to make a calculated dimension for a range of weeks (Chron_Week).
When I use the IF statement = IF(Chron_Week >40,Chron_Week) it works fine and gives me all Chron_Week's above week 40 but I want the range to be between week 41 and 49.
When I try =IF(Chron_Week >40<50,Chron_Week) it comes back with error in expression.
Would it be possible for me to put a variable in there with the week range of 41 to 49?
Thanks,
Nick
Hi @NickBentley ,
The syntax is like below:
IF(Chron_Week >40 and Chron_Week <50,Chron_Week)
Regards
Anthony
Hi @NickBentley ,
The syntax is like below:
IF(Chron_Week >40 and Chron_Week <50,Chron_Week)
Regards
Anthony
Thanks Anthony, your reply got it working.
I noticed the space I was using in between Chron_Week and '<' was causing issues.
Cheers,
Nick