set analysis

[#1]

Hi everyone;

I need to get the sum about all orders different with description 'ON HOLD'  the dimention that have this description is called Delay_Days:

i was trying inside of a text-box-component but doesn't work this way:

= if(Delay_Days<> 'ON HOLD',Sum({$<ORDENES={'On Time'} >} NumberofLines),0)

OTHER WAY:

Sum (IF(Delay_Days<> 'ON HOLD',({$<ORDENES={'On Time'} >} NumberofLines),0)

BOTH WAYS doesn' t can you help please!!!!!

[#2]

This may do it, but you'll need to qa the result to make sure it's working as expected:

sum({$<ORDENES={'On Time'} >} if(Delay_Days<> 'ON HOLD', NumberofLines))

Best,

Matt

[#3]

thanks for your help but may be there are something wrong in my script because doesn't work ok anywhere thanks very much 

[Gysbert_Wassenaar]

Try: Sum ({$<ORDENES={'On Time'},Delay_Days -= {'ON HOLD'} >} NumberofLines). The -= means unequal.

[#5]

Ok I will try !!! thanks very much for your help!!!!