Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have an issue , my amount vary from $0.01 till $100,000
In situation amount more then $10 i need round up. and amt less then that i don't want it to round up.
Because
0.10 if round up to 0.5 is a very big diff
10.1 round up to 10.5 is a vey small diff
Paul
Hi Paulyeo11
Ravichandran expression is correct, u can go through the attached application for sample.
Enclosed my QV doc.
Hi All
Can some one share with me this one.
Paul
see the attached file
Hi
may be like this
if(points>=10,Round(points),points)
HTH
Ravi N.
Hi Paulyeo11
Ravichandran expression is correct, u can go through the attached application for sample.
Hi Sir
Thank you it work fine now.
Paul
Hi Sunil
Just saw yr approach , very innovative , let me think , i may apply your into my doc.
Paul