Working with Math column to create a simple Sum I discovered this rare problem when some cells are blank (empty). My formula is:
Total= Qty1*Price1+ Qty2*Price2+ Qty3*Price3
Everything is fine when all cells have some value but, if there is (are) some blank cell(s) in the formula, the result is completely crazy and funny. See my screenshot please
The workaround could be to use the What-If-Else tool but I will have to create more new columns and the APP would load more unnecessary data for this issue. My real APP and formula has 16 tags (variables) and don’t want to create these dummy variables by this bug.
Thanks in advance for the help and patch!