Issue with rounding

[#1]

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

[Gysbert_Wassenaar · Accepted solution]

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

[#3]

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))