Convert negative values to postive

[#1]

Hi

How can i convert a measure which is displaying as all negatives to positive vales?

Thanks

[Anonymous]

Try to load

-field

[maxgro]

fabs for absolute value

[PrashantSangle]

Hi,

In front end you can use

fabs()

or

multiply with field into -1

Regards

[ashfaq_haseeb]

Hi,

look at Fabs() function

Regards

ASHFAQ

[#6]

do you have an example

[#7]

sorry do you have an example

[amit_saini]

Hi,

Try this:

You could change it in Number formatting tab.For both positive and negative as same

#,###;#,###

Second try this also:

use fabs() function hope this could help u

from QV Help :

fabs( x )

The absolute value of x. The result
is a positive number.

Examples:

fabs( 2.4 ) returns 2.4

fabs( -3.8 ) returns
3.8

Thanks,

AS

[PradeepReddy]

Try with FABS()...

Ex:

FABS(2.4 ) returns 2.4

FABS(-3.8 ) returns 3.8

[ashfaq_haseeb]

Hi,

Run this script and drop value1 and value2

Load *,fabs(Value1) as Value2;

load * Inline

[

Date,Value1

01-01-2014,-1,

02-01-2014,-2,

03-01-2014,-1

04-01-2014,-4,

05-01-2014,-1,

06-01-2014,-6,

07-01-2014,-2,

08-01-2014,-8

09-01-2014,-5,

10-01-2014,6,

]

Regards

ASHFAQ