Remove minus sign from negative numbers

K

Khushalay

Registered User.
Local time
Yesterday, 18:53
Joined
Apr 16, 2016
Messages
180
Hi Friends

I have a calculated value on the report and it generally is a positive value but rarely it comes as a negative. I want it to be displayed without the minus sign i.e. the absolute value.

How to achieve that.

Thanks
 
You could use the Abs function in an expression in the source query, e.g.,

BigLie: Abs([FieldName])

Somehow this really sounds like a bad idea. How is it that it makes no difference if the reported amount is positive or negative?
 
How can I change it in form plz?
 
If is already a calculated value then just put whatever you have inside the Abs function, e.g,

=Abs(wherever is there)
 
Can't you upload the database or a stripped down copy of it?
 
I noticed a problem when I tried doing this. If you change the control source of a textbox from [FieldName] to =Abs([FieldName]) it will show a circular reference error if the textbox has the same name as the field name. If this is the case you will need to change the name of the textbox.

This probably isn't the problem you are experiencing as this show up in the report view with #TYPE and not #NAME. #NAME usually indicates an incorrect field name.

I suggest using the expression builder for this. Click on the ellipsis (...) in the control property, pick the Abs function and then the report field.
 
Put it in the underlying query so you have both values available to your report/form. And is this a form or a report - you have used both terms?

AbsValue : Abs([YourField])
 
You must log in or register to reply here.

Similar threads

D
Make a negative number a "0"
Replies
19
Views
660
DHookom
DHookom
E
Solved DLookup value display with a minus sign
Replies
16
Views
655
Mark_
M
J
Solved Count blank detail sections in report to minus from grand total
Replies
1
Views
309
Jomat
J
J
Negative values are seen as positive
2
Replies
23
Views
1,275
LarryE
LarryE
B
Solved Remove certain parts of a concatenated textbox
Replies
8
Views
485
gemma-the-husky
gemma-the-husky

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom