Skip to Content
0
Former Member
Jan 06, 2009 at 06:35 AM

Minimum which is not equal to 0 zero

918 Views

Hello experts

In a query I have multiple columns with values. I wish to find Minimum of these values.

However I do not want 0's to be considered. Please help.

E.g.

Material | Price1 | Price 2 | Price 3| Price 4 | Minimum

M1 | 10 | 0 | 12 | 8 | here I need 8

However when I apply Min(, ) function it gives 0. So what is the way to exclude 0?

Regards,

Sanjyot Mishra