Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
Below expression work fine in my list box 1 :-
=If(Aggr(SUM(C_ONHAND_AMT)/sum(B_COGS),DESC_INVENTORY_TABLE) >0 and Aggr(SUM(C_ONHAND_AMT)/sum(B_COGS),DESC_INVENTORY_TABLE)<10, dual('1-10',1),
If(Aggr(SUM(C_ONHAND_AMT)/sum(B_COGS),DESC_INVENTORY_TABLE) >10 and Aggr(SUM(C_ONHAND_AMT)/sum(B_COGS),DESC_INVENTORY_TABLE)<20, dual('11-20',2),
If(Aggr(SUM(C_ONHAND_AMT)/sum(B_COGS),DESC_INVENTORY_TABLE) >20 and Aggr(SUM(C_ONHAND_AMT)/sum(B_COGS),DESC_INVENTORY_TABLE)<30, dual('21-30',3),
If(Aggr(SUM(C_ONHAND_AMT)/sum(B_COGS),DESC_INVENTORY_TABLE) >30 and Aggr(SUM(C_ONHAND_AMT)/sum(B_COGS),DESC_INVENTORY_TABLE)<100, dual('31-100',4),
If(Aggr(SUM(C_ONHAND_AMT)/sum(B_COGS),DESC_INVENTORY_TABLE) >100 and Aggr(SUM(C_ONHAND_AMT)/sum(B_COGS),DESC_INVENTORY_TABLE)<2000, dual('101-2000',9), Dual('0', 0))))))
May i know how to turn on " Number of turn " = 0 by using the button ?
Paul Yeo
My QVW
What you want to show if you hit the button?
Hi Anil
I want to turn on number of turn = 0
Paul
Still Not sure, Sorry.
Hi Anil
Do you mean you not sure what i want to achieve ?
Paul Yeo
what is S mean ?
I am not followed you, What you are going to achieve. usually,We have concept called Auto Hide Show and Hide Multiple Objects - YouTube but your intend is bit different. Before produce some inputs if you explain exactly what your needed then it saves Time
Hi Anil
I need to do a drill down analysis , as stock number of turn = 0 , is having a issue. So i need to drill in these list of items , and further analyse those items by period. to find out the real issue.
Paul
It make sense now. Will looks this once i get chance to open the app