Calculated Dimension - Date Range

[NickBentley]

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 

[anthonyj · Accepted solution]

Hi @NickBentley ,

The syntax is like below:

IF(Chron_Week >40 and Chron_Week <50,Chron_Week)

Regards

Anthony

[NickBentley]

Thanks Anthony, your reply got it working.

I noticed the space I was using in between Chron_Week and '<' was causing issues.

Cheers,

Nick