removing zero values from an expression

[#1]

I have a straight table.  One expression is =MachValue*(OpQty - (OperationYield+Scrap)) this will return zero values.  I want the straight table to report out all lines which do not have zero value.  I have tried marking the suppress zero values and suprees when null but that has not proved successful.  I don't think I can do anything different in my load because this is a calculation.  Any help is appreciated.

[PrashantSangle]

Hi,

Did you try with if condition.

Like

if(MachValue*(OpQty - (OperationYield+Scrap))<>0,MachValue*(OpQty - (OperationYield+Scrap)))

and also tick on supress null values.

Regards,

[#3]

When I used that formula my machine time changed from zero to -. It did not remove it from my table. I still have the suppress zero and suppress null check boxes checked on the presentation tab. What is interesting is it actually changed it from a zero to a null but I still can’t get those lines to not show on my straight table. Does the picture below help at all?

Kimberly Glidewell

E-Z-GO/Textron

Systems Analyst

Phone: 706-560-6091

Fax: 706-826-1210

[PrashantSangle]

Hi,

As per provided expression,

It is working fine for that particular Expression only.

Just confirm it by disabling all other expression except provided solution expression.

It will give you only those value which does not contain 0.

In provided image, You are calculating some more expression also, which contain values on that row

Therefore our expression is showing -

I hope you understand, what I want to say.

One more thing if possible share you sample apps.

Regards,