Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
try second expression with (vLADEDATUM should be value in MM/YY
count ({$ <Monat_Jahr={'$(=vLADEDATUM)'},FARBE={2}>} distinct Supplier)
try second expression with (vLADEDATUM should be value in MM/YY
count ({$ <Monat_Jahr={'$(=vLADEDATUM)'},FARBE={2}>} distinct Supplier)
Thanks
Seems i used $ once but inside with variable and dint try this way!