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,
sum(if(getselectedcount(month)=0 or getselectedcount(day)=0 or getselectedcount(year)=0,qty,mnth_qty)
getselectedcount(field) :Gets the output of number of values which we selected from field.
if you select jan,feb from month field,the output will be 2.
so when ever you didn't make any selections on any one of month,day,year.
the output will be =0,
The condition becomes true because the selection count of the field =0.So the the "Qty" will be the result.
else "mnth_qty"
Hope i make it clear for you
HI,
The flow of expression is this way.
If the Value is not selected in Filters like Month, Day and Year then sum the qty of any value is selected from any of this 3 filters then sum the Month Qty.
Regards,
Kaushik Solanki
Suppose you have..fields month,day,year
if you select any one/two of above three fields TRUE statement will be exicuted.(qty)
if you select three of above fields FALSE statement will be exicuted.(mnth_Qty)
This will working as like below
If no selections Sum(qty) else Sum(mnth_qty)
getselected count function is count the value ,right.and then it'll check condition.am i right.is there any option instead of this function
Hi Anil,
Here or is included in between the conditions.so if he may select any one of the field that will be true.
In above if one condition is true then true is executed.
Am i correct?
Hi,
sum(if(getselectedcount(month)=0 or getselectedcount(day)=0 or getselectedcount(year)=0,qty,mnth_qty)
getselectedcount(field) :Gets the output of number of values which we selected from field.
if you select jan,feb from month field,the output will be 2.
so when ever you didn't make any selections on any one of month,day,year.
the output will be =0,
The condition becomes true because the selection count of the field =0.So the the "Qty" will be the result.
else "mnth_qty"
Hope i make it clear for you
yes..suppose if u select 2 fields from month field.then getselectedcount(month)=2..
Assumption is correct
If you select anything from those three statements it will give True condition or else false condition
Reply for Last response, yes you are right. There is no other option. Only we have GetSelectedCount() it will get the count of dimension where out static value gives.
Thanks to all.