Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
How can i convert a measure which is displaying as all negatives to positive vales?
Thanks
Try to load
-field
fabs for absolute value
Hi,
In front end you can use
fabs()
or
multiply with field into -1
Regards
Hi,
look at Fabs() function
Regards
ASHFAQ
do you have an example
sorry do you have an example
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 :
The absolute value of x. The result
is a positive number.
fabs( 2.4 ) returns 2.4
fabs( -3.8 ) returns
3.8
Thanks,
AS
Try with FABS()...
Ex:
FABS(2.4 ) returns 2.4
FABS(-3.8 ) returns 3.8
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