cancel
Showing results for 
Search instead for 
Did you mean: 

"Abs" and "Floor" function does the same job ???

Former Member
0 Kudos

hello experts,

which of these function i should use to get absolute value.

can anybudy explain the difference??

View Entire Topic
Former Member
0 Kudos

Hello Anubhav,

Could you please elaborate the query as there is an available function in Webi Abs() that returns absolute value of a number.

for e.g. Abs(-12.5) will return 12.5

Regards

Niraj

Former Member
0 Kudos

floor function also does the same na ???

Former Member
0 Kudos

=Floor(-12.5) will return -13 it rounds the number down to nearest integer.

=Ceil(-12.5) will return -12 it rounds the number up to nearest integer.

but both dosen't removes negative sign. However Abs(-12.5) will remove negative sign and does not round off.

Regards

Niraj

Former Member
0 Kudos

Ok thanks !!