Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

rounding issue

4.255, when round it , i become 4.25instead of 4.26. 

untitled.JPG

i want it to be 4.26,which should be correct in my understanding

untitled.JPG

12 Replies
Sokkorn
Master
Master

Hi,

Can you try to create Text Object and use this expression =Round(4.255,0.01) then give me the result. Just want to know it cause from your table or function.

Regards,

Sokkorn

Not applicable
Author

=Round(4.255,0.01)  , it comes out 4.26

but

=round(4.655,0.01), it comes out 4.65

why?

Sokkorn
Master
Master

Hi,

Can you try this one

=Ceil( 4.655 , 0.01 )

Rgds,

Sokkorn