Not return 0 values

[jenmclean]

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))

[eduardo_sommer]

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

[preminqlik]

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))

[jenmclean]

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

[eduardo_sommer]

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

Eduardo