Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Issue with rounding

Hi,

I have a small / requirement in rounding.

I don't want to show records ending in .99. Can someone please share a sample expression.

Thank you in advance.

Regards,

Sachin

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Try this expression instead: sum({<Item={"=round(frac(sum(Cost)),0.01)<>0.99"} >}Cost)


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Gysbert_Wassenaar

Try this expression instead: sum({<Item={"=round(frac(sum(Cost)),0.01)<>0.99"} >}Cost)


talk is cheap, supply exceeds demand

View solution in original post

Not applicable
Author

Thank u Sir. It worked.

sunny_talwar

You might also be able to use If statement:

If(Round(Frac(sum(Cost)), 0.01) <> 0.99, Sum(Cost))


Capture.PNG