How to remove -ve sign from the value -0.0 as 0.0

[#1]

Dear friends,

Please help me out here. very urgent.

I have a year on year(YoY) set analysis expression which is giving me both +ve and -ve values.

But, some values are there as -0.001234567

So I customer wanted to see only up to two decimal places and when I do that these value is coming as -0.0

I wanted to show -0.001234567 as 0.0(need to remove negative sign)

I have tried with round(expression,0.1) but this is not giving correct result in all cases.

Please help.

Thanks,

SHAMLY P T

[sunny_talwar]

May be this:

Ceil(Expression, 0.1)

[Chanty4u]

hi,

u can use

Fabs( urfield)

it will gives u +ve values.

and in number tab u can chnge the  format to get exact number

*** Negative Value to Positive Value ***

In Pivot table, How to fabs first and then sum

[Kushal_Chawda]

=round(YourExpression *-1,0.1)

[sunny_talwar]

Kush, won't this convert a positive value into a negative one?

[Kushal_Chawda]

Yeah correct. I forgot there is positive too.

round(fabs(YourExpression),0.1)

[Chanty4u]

chk sample

[#8]

Sunny,

Thanks for ur reply.

But ceil and Round will not give correct value here.

I have values like -0.0123, -0.53,-0.7,0.0001 etc..

Round and ceil is making 0.6 as 1.

I want -0.023 to be shown as 0.0

I want -0.0 to be shown as 0.0

I want 0.6 to be shown as 0.6

I want -0.6 to be shown as -0.6

I want -0.0 to be shown as 0.0

[sunny_talwar]

0.6, -0.023 are working, the one which isn't working is -0.6

May be use an if statement to get it to work in that case

[sunny_talwar]

May be try this:

=Num(If(Expression < -0.1, Expression , Ceil(Expression , 0.1)), '#.#')