Print Page | Close Window

Negative Value in Closed brackets

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22498
Printed Date: 04 May 2024 at 10:07pm


Topic: Negative Value in Closed brackets
Posted By: reachpathuri
Subject: Negative Value in Closed brackets
Date Posted: 15 Nov 2017 at 9:39pm
Hello All,
I developed a crystal report in 2016. i am doing a calculation on 2 columns. I have receipts total and Payments total. if payments total - receipts total = -1000. This value i should show in closed brackets only(-1000), if i get the negative value. If i get the positive value then leave as it is. How to show the negative value in closed brackets?
Please help .

Thanks



Replies:
Posted By: DBlank
Date Posted: 16 Nov 2017 at 2:21am
right click on the field
select format field
select the number tab
in the style select the (1123) option



Print Page | Close Window