Joined: 10 Jan 2011
Location: United States
Online Status: Offline
Posts: 65
Topic: Putting () around a numberic field Posted: 13 May 2011 at 5:40am
Good Morning,
I have a numberic field that represents a negative value even though the value is not negative. Is there any way in crystal to make the field have () aound it without actually turning it negative?
Joined: 22 May 2009
Online Status: Offline
Posts: 347
Posted: 13 May 2011 at 5:58am
^^^^^^^ will actually turn it into a string. So it will work as long as you are not calculating totals. If you are trying to calculate a total based on that field then you will have to find antoher way.
Joined: 22 May 2009
Online Status: Offline
Posts: 347
Posted: 13 May 2011 at 7:28am
Only thing I can think is to have two fields, one as the display and one that you base the calculations off of. So the display string will be {@displaynumericfield} which could be the formula above. Then put the actual field {table.numericfield} on the same line, but suppressed so it doesn't display and use that for the calculations.
Joined: 22 May 2009
Online Status: Offline
Posts: 347
Posted: 13 May 2011 at 7:31am
I believe he is just trying to display a value, such as 123 as (123), but without (123) being considered a negative number. So, as I understand it, a negative number would display as (-123).
Joined: 11 Mar 2011
Location: United States
Online Status: Offline
Posts: 251
Posted: 13 May 2011 at 11:29am
My understanding is that in 2008 you can use the Format Field to tell it to "Use Accounting Format" and select "Reverse Sign For Display" and it will show as negative but still be treated as positive.Doing it this way uses the default settings on your computer so you'll have to set them the way you want it to show.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
