Skip to main content
Solved

Formula error when dividing currency by integer of 2

  • February 20, 2016
  • 1 reply
  • 12 views
R

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?

    1 reply

    K
    Forum|alt.badge.img+5
    • Katherine_Duh
    • Inspiring
    • Answer
    • February 20, 2016

    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?

    Terms & ConditionsAccessibility statement