Discussions

 View Only
Expand all | Collapse all

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

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

    Posted 07-11-2019 18:16
    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.


  • 2.  RE: Why does my calculated currency field sometimes show -$0.00 rather than $0.00

    Posted 07-11-2019 18:27
    I suggest that you round your result to the nearest penny.

    Round([calculated field], 0.01)


  • 3.  RE: Why does my calculated currency field sometimes show -$0.00 rather than $0.00

    Posted 07-11-2019 18:34
    Worked like a charm. You're the best. Thanks Mark!