4 Replies Latest reply: May 30, 2014 5:47 PM by Eduardo Sommer

# Not return 0 values

How would I write this expression so that it will only show values that are greater than 0?

(Sum({\$<PARTS|SubTypeDesc-={'NATIONAL ACCOUNTS PART', 'NATIONAL ACCOUNTS BATTERY', 'NET STATE'}, PARTS|ActiveFlag={1}>}PARTS|OnHandInv)=0, Null(), (PARTS|OnHandInv-PARTS|Obligated-PARTS|KeepOnHand))

• ###### Re: Not return 0 values

Try

if((Sum({\$<PARTS|SubTypeDesc-={'NATIONAL ACCOUNTS PART', 'NATIONAL ACCOUNTS BATTERY', 'NET STATE'}, PARTS|ActiveFlag={1}>}PARTS|OnHandInv)=0, Null(), (PARTS|OnHandInv-PARTS|Obligated-PARTS|KeepOnHand))> 0,

(Sum({\$<PARTS|SubTypeDesc-={'NATIONAL ACCOUNTS PART', 'NATIONAL ACCOUNTS BATTERY', 'NET STATE'}, PARTS|ActiveFlag={1}>}PARTS|OnHandInv)=0, Null(), (PARTS|OnHandInv-PARTS|Obligated-PARTS|KeepOnHand)))

if the result is 0 or less, the expression will return a null value

Eduardo

• ###### Re: Not return 0 values

hi there try  this

(Sum({\$<PARTS|SubTypeDesc-={'NATIONAL ACCOUNTS PART', 'NATIONAL ACCOUNTS BATTERY', 'NET STATE'}*{'=(Sum({\$<PARTS|SubTypeDesc-={'NATIONAL ACCOUNTS PART', 'NATIONAL ACCOUNTS BATTERY', 'NET STATE'}, PARTS|ActiveFlag={1}>}PARTS|OnHandInv)=0, Null(), (PARTS|OnHandInv-PARTS|Obligated-PARTS|KeepOnHand))>0'}, PARTS|ActiveFlag={1}>}PARTS|OnHandInv)=0, Null(), (PARTS|OnHandInv-PARTS|Obligated-PARTS|KeepOnHand))

• ###### Re: Not return 0 values

Clarifiying, I need it to only display results that are postive or negative and NOT 0.

• ###### Re: Not return 0 values

Just change the >0 to <>0 in my earlier suggestion (in the end of second line)

Eduardo