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