Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
Please check attachment, would like to create a filter by status using the same expression in the straight table
Did not get you what you want to see in your sheet as an output?
Hey Vishwa,
Thanks for the reply, would like to create a filter by status using the same expression in the straight table
Try this in your listbox expr:
= if(Item.STATUS_COMP='P',Item.STATUS_COMP,
if(Aggr(sum(ASCP.DMND), ASCP.ITEM, ASCP.ORG) > 0,
if(Aggr(sum(ASCP.ON_HAND-ASCP.DMND), ASCP.ITEM, ASCP.ORG) < 0,'A','S'),'P'))
Vishwa,
this is what happening when I select 'A ' from filter
if(Item.STATUS_COMP='P',Item.STATUS_COMP,
IF(Aggr(sum(ASCP.DMND),ASCP.ITEM,ASCP.ORG)>0,if(Aggr(sum(ASCP.ON_HAND-ASCP.DMND),ASCP.ITEM,ASCP.ORG)<0,'A','S'),'P'))
Hello Sasi,
It is the same expression what Vishwa posted it's giving me wrong selections when I select something from the filter as the screenshot above.
thanks
May be try
=If(Item.STATUS_COMP='P',Item.STATUS_COMP,
If(Aggr(sum(ASCP.DMND),ASCP.ITEM,ASCP.ORG)>0 AND Aggr(sum(ASCP.ON_HAND-ASCP.DMND),ASCP.ITEM,ASCP.ORG)<0,'A','S'))
Can you break down your requirement for status A, P and S please. There is something to be tweaked around your if conditions. Please break down individually and let us know so that we can rebuild the expressions. Like what is the condition to get A, P and S accordingly.
Tried it seems like a glitch see attached if I select 'A'
When I select 'S', 'P' is working fine