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.
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
Enclosed my QV doc.
Can some one share with me this one.
see the attached file
Just saw yr approach , very innovative , let me think , i may apply your into my doc.
may be like this
Ravichandran expression is correct, u can go through the attached application for sample.
Thank you it work fine now.
Retrieving data ...