Why does my calculated currency field sometimes show -$0.00 rather than $0.00

  • 0
  • 1
  • Question
  • Updated 1 month ago
  • Answered
I have a calculate currency field but in some forms and reports when the balance is zero sometimes it shows -$0.00 (minus) and sometimes it shows $0.00 which is what I want. This is totally annoying and I can't figure out how to get it consistent across the board.
Photo of Dawn Rene

Dawn Rene

  • 526 Points 500 badge 2x thumb

Posted 1 month ago

  • 0
  • 1
I suggest that you round your result to the nearest penny.

Round([calculated field], 0.01)
(Edited)
Photo of Dawn Rene

Dawn Rene

  • 526 Points 500 badge 2x thumb
Worked like a charm. You're the best. Thanks Mark!