Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
psk180590
Creator III
Creator III

Round of to two decimals

Hello All,

I have my data in the below format and would like to Round it off to two Decimals

0,4989    -      0,49

1,1960    -      1,19

23,4537   -    23,45

100,3268 -   100,32

Tried with Round and Ceil Function but, doesn't workout as needed.

TIA!!

1 Solution

Accepted Solutions
sunny_talwar

May be this

Floor(Number, 0.01)

View solution in original post

1 Reply
sunny_talwar

May be this

Floor(Number, 0.01)