date Variable not working in set analysis

Samrithi — Sun, 23 Jun 2019 21:32:23 GMT

Hi,

We are using Sep 2018 Version 12.5.

I have Expression below using Date range variable in set analysis but its not getting filtered on variable date range.

Its working on my local desk because I am using latest version.

Tried in many different ways but still not working. please suggest.

And if any link for sept 2018 version 12.5 is there online, please send me the link so that I can try installing on local machine and try the same expression.

"(if([BBK.WeekDay]='Thu',
num((rangesum(Before(sum({<[BBK.PERIOD]={">=$(=vMinDate)<=$(=vMaxPeriod)"}>}[BBK.BBK_ITEM]),0,day([BBK.PERIOD])))/
rangesum(Before(sum({<[BBK.PERIOD]={">=$(=vMinDate)<=$(=vMaxPeriod)"}>}[BBK.BBK_OPP_ITEM]),0,day([BBK.PERIOD])))),'#0.00%')".

I used in different ways also below but still not working.

"{">=$(=$(vMinDate))<=$(=$(vMaxPeriod))"} or {">=$(=date($(vMinDate))<=$(=date(vMaxPeriod))"}"

Appreciate the solution or the link to download sep 2018 version 12.5 version.

Thanks.

topic date Variable not working in set analysis in App Development

date Variable not working in set analysis