How to remove numbers after the decimal point?

prash_
Level 3
How to remove numbers after the decimal point?

I have an output like 1567.88 and I just want 1567 

I tried using the round after round its giving 1568. 

Any solution on this?

0 Kudos
1 Reply
sj0071992

Hi,

 

Try using function FLOOR()

This will returns the largest integer value which is less than or equal to the value used as a parameter.

For example: FLOOR(79.9) will give 79

 

Thanks