Hi Mark, I found a way to resolve that and the formulas are shared here. Thanks for your help and guidance. Now I have a clean spreadsheet without zeros. (If I could not do this properly with expression, I would have to think of making an Appscript f...

Hi Graham, Yes you have correctly identified that QTY column in number type actually do not save data on spreadsheet not as zero but as BLANK. So essentially if that is the case that we need to treat this field as blank but in number types. I found a...

Hi Graham, Thanks for your suggestion. I had followed that. The suggested method removes the zeros but creates another problem as all Totals (where qty is not zero or having >0 value) are now getting zero values which is wrong. The output right now c...

I think this problem needs more attention from experienced experts.

I am sorry to celebrate early. IF( [qty]=0 , NUMBER("") , [qty]*[price] ) That expression also did not work. ITEM1 ITEM1 DESCRIPTION ITEM1 UNIT ITEM1 QTY ITEM1 UNIT PRICE ITEM1 TOTAL PRICE ITEM1 DISCOUNT RATE ITEM1 DISCOUNT ITEM1 DISCOUNTED PRICE ITE...