Skip to main content (Press Enter).
Sign in
Skip auxiliary navigation (Press Enter).
Support
Quickbase University
Skip main navigation (Press Enter).
Toggle navigation
Search Options
Home
Communities
All Posts
All Communities
My Communities
Getting Started
Events
Qrew Groups
Discussions
View Only
Community Home
Discussion
64.7K
Library
549
Blogs
177
Events
0
Members
46.7K
Back to discussions
Expand all
|
Collapse all
sort by most recent
sort by thread
Why does my calculated currency field sometimes show -$0.00 rather than $0.00
Archive User
07-11-2019 18:16
I have a calculate currency field but in some forms and reports when the balance is zero sometimes it ...
QuickBaseCoach Dev./Training
07-11-2019 18:27
I suggest that you round your result to the nearest penny. Round([calculated field], 0.01)
Archive User
07-11-2019 18:34
Worked like a charm. You're the best. Thanks Mark!
1.
Why does my calculated currency field sometimes show -$0.00 rather than $0.00
0
Like
Archive User
Posted 07-11-2019 18:16
Reply
Reply Privately
Options Dropdown
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
0
Like
QuickBaseCoach Dev./Training
Posted 07-11-2019 18:27
Reply
Reply Privately
Options Dropdown
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
0
Like
Archive User
Posted 07-11-2019 18:34
Reply
Reply Privately
Options Dropdown
Worked like a charm. You're the best. Thanks Mark!
×
New Best Answer
This thread already has a best answer. Would you like to mark this message as the new best answer?
Skip Navigation Links
Terms and Conditions
Copyright . All rights reserved.
Powered by Higher Logic