Comparing Date with variable in Set Analysis

[supriyabiware]

Hello All,

I have to write a conditional count in set analysis (if condition works but is very slow)

I tried 3 options -

1. count ({$ <Monat_Jahr={"=$(=Date(LADEDATUM,'MM/YY'))"},FARBE={2}>}  distinct Supplier)

2. count ({$ <Monat_Jahr={'=(vLADEDATUM)'},FARBE={2}>} distinct Supplier)

3.count ({$ <Monat_Jahr={'09/18'},FARBE={2}>}  distinct Supplier)

only 3rd one seems to work correct (which i have given manually) , other two seems to work but with wrong results.

Anyone knows what possibly is going wrong?

Thanks,

Supriya.

[Anonymous · Accepted solution]

try second expression with (vLADEDATUM should be value in MM/YY

count ({$ <Monat_Jahr={'$(=vLADEDATUM)'},FARBE={2}>} distinct Supplier)

[supriyabiware]

Thanks

Seems i used $ once but inside with variable and dint try this way!