Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hai,
sum(if(getselectedcount(month)=0 or getselectedcount(day)=0 or getselectedcount(year)=0,qty,mnth_qty)
can anyone explain how does it works..what is the result of this.
Thanks in advance
Hi,
It will work based on 4 cases:
1. if you select only month filter result is true and display qty.
2. if you select month and day, result will be true and display qty.
3.if you select month,day and year result will false and display mnth_qty.
4.Even if you not select any filter, result will be true and display qty.