Remove minus sign from negative numbers

[Khushalay]

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

 

[sneuberg]

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?

 

[Khushalay]

How can I change it in form plz?

 

[sneuberg]

If is already a calculated value then just put whatever you have inside the Abs function, e.g,

=Abs(wherever is there)

 

[Khushalay]

Where to add this?

 

[sneuberg]

Where to add this?

The Control Source of the applicable report textbox.

 

[Khushalay]

It shows #NAME

 

[sneuberg]

Can't you upload the database or a stripped down copy of it?

 

[sneuberg]

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.

 

[Minty]

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])

 

[Khushalay]

Thnaks alot, it worked