Skip to main content
Question

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

  • July 11, 2019
  • 0 replies
  • 39 views

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.
This topic has been closed for replies.

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

Round([calculated field], 0.01)

  • Author
  • Registered
  • July 11, 2019
Worked like a charm. You're the best. Thanks Mark!