11 Replies Latest reply: Jan 15, 2018 7:37 PM by Yeo Poh sai

# List box expression created 0 1-10 11-20 may i know how to use button to turn on 0 ?

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

• ###### Re: List box expression created 0 1-10 11-20 may i know how to use button to turn on 0 ?

What you want to show if you hit the button?

• ###### Re: List box expression created 0 1-10 11-20 may i know how to use button to turn on 0 ?

Hi Anil

I want to turn on number of turn = 0

Paul

• ###### Re: List box expression created 0 1-10 11-20 may i know how to use button to turn on 0 ?

Still Not sure, Sorry.

• ###### Re: List box expression created 0 1-10 11-20 may i know how to use button to turn on 0 ?

Hi Anil

Do you mean you not sure what i want to achieve ?

Paul Yeo

• ###### Re: List box expression created 0 1-10 11-20 may i know how to use button to turn on 0 ?

what is S mean ?

• ###### Re: List box expression created 0 1-10 11-20 may i know how to use button to turn on 0 ?

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

• ###### Re: List box expression created 0 1-10 11-20 may i know how to use button to turn on 0 ?

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

• ###### Re: List box expression created 0 1-10 11-20 may i know how to use button to turn on 0 ?

It make sense now. Will looks this once i get chance to open the app

• ###### Re: List box expression created 0 1-10 11-20 may i know how to use button to turn on 0 ?

Are you still looking anything? If you got please post and close the thread

• ###### Re: List box expression created 0 1-10 11-20 may i know how to use button to turn on 0 ?

Hi Anil

Actually i am still hope to learn how to do that , in case there is no solution available , i should close this thread by click on what ?

Paul