Solved

Formula error when dividing currency by integer of 2

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

Best answer by Katherine_Duh

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?

Did this topic help you find an answer to your question?

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?

1 reply