Skip to main content

Formula error in inventory (imported cvs) when computing unit price.


COST column is specified as currency ($) and QTY column is integer 2 numeric.



U/PRICE column contains formula as follows: COST/QTY


(Result should be $ but displays as integer 2



Record from db is COST OF $1.00 divided by QTY OF 10 = U/PRICE BLANK INSTEAD OF $.10



THANKS

If the result should be dollars in the column, but instead it’s an integer, you should change the format to currency.



This is a formula where the output is set to integers, so in the last row, it rounds .10 down to 0.




But if you set the format to “Currency”—




Then it’ll work:




Does this help?


Reply