There are lot of problems associated with Appsheet when computing calculations like invoices return unwanted ZEROS when the quantity is zero. (If we can stop this zero appear in quantity field we can solve this issue but since it is a number field, we need it to be a number field to apply simple math formulas)
I could not find any answer to solve this problem. Eg. If the quantity is zero, then the Total Price (Qty * Unit Price) =0 and the Invoice template will be filled with unwanted zeros.
Tried many ways including taken sync with spreadsheet (googlesheet) but unfortunately this do not work in my app as still it gives those unwanted zeros.
Spreadsheet it is working fine but not in the Appsheet.
If you have simple method or advice on to use the correct expression would be great help for all who have this simple problem.
These formulas are working fine in Google sheets where BK15= 0 (zero value) eg: Qty and following formula does not return “0” (zero value).
=IF(BK15>0,(BK15BL15),“”)
and this also
=IF(BK18=0,“”,(BK18BL18))
BK15 is Qty, BL15 is Unit Price and BM15 is Total Price.
When BK15 is zero there is no return value zero in goggle sheet but if use the same formulas in appsheet it gives all unwanted zero in computation and this is not what we want to appear in the invoice as it is not needed to show zero values for Totals.
This is another expression that works fine in the google sheet but its a real pity why can’t we get that in appsheet?
Here is the formula; =IF(BK15>0,(BK15*BL15),“”)
In my Invoice Template there are 3 columns appear zeros when the quantity is zero. They are: Total Price, Discount and Discounted Price.
Hope you can help me with this as I can’t simply understand why these google sheet formulas are not compatible with appsheet?
BTW: I have also tried making 0;0;;@ numbering format in the appsheet number formatting and use that sync with appshet. There is no use still appsheet recognize zero value as zero and when multiply something with a zero value it gives zero values.
If we can generate an expression that do not take zero values in computation formulas we can resolve this I guess. But still can’t understand why appsheet do not offer same result in google sheet when the appsheet has been created with googlesheet?
Thanks.
Dinesh C.
