Display a negative value as positive

[Sandy Thomson]

In a report i need to show a negative currency value as a
positive value - how can i do this?


Thanks

 

[PC]

You could try an expression either in the underlying query or in the report
itself somehing like:
([NegValue]-([NegValue]*2))

Paul

 

[Gary Walter]

In a report i need to show a negative currency value as a
positive value - how can i do this?

or if F1 has both positive and negative values
and you want to show all as positive,

=Abs([F1])

 

[Codemonkey]

Or even ([NegValue]*-1)

You could try an expression either in the underlying query or in the report
itself somehing like:
([NegValue]-([NegValue]*2))

Paul

In a report i need to show a negative currency value as a
positive value - how can i do this?


Thanks

 

[PC]

There's always a better way

Or even ([NegValue]*-1)

You could try an expression either in the underlying query or in the report
itself somehing like:
([NegValue]-([NegValue]*2))

Paul

In a report i need to show a negative currency value as a
positive value - how can i do this?


Thanks

 

[John Spencer (MVP)]

Or use the Format property of the control to show the number without any
positive or negative indicator.

Or use Abs(TheValue) which will return the value without any sign. The
advantage of this is that if the value is positive you still end up with a
positive (unsigned) value.

Or even ([NegValue]*-1)

You could try an expression either in the underlying query or in the report
itself somehing like:
([NegValue]-([NegValue]*2))

Paul

In a report i need to show a negative currency value as a
positive value - how can i do this?


Thanks