topic Re: Calculated Dimension - Date Range in App Development

Calculated Dimension - Date Range

NickBentley — Fri, 11 Mar 2022 01:02:38 GMT

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

Re: Calculated Dimension - Date Range

anthonyj — Fri, 11 Mar 2022 02:30:06 GMT

Hi @NickBentley ,

The syntax is like below:

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

Regards

Anthony

Re: Calculated Dimension - Date Range

NickBentley — Fri, 11 Mar 2022 03:19:23 GMT

Thanks Anthony, your reply got it working.

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

Cheers,

Nick