Page 1 of 1

Posted: Wed Jan 04, 2012 10:16 pm
by pandeesh
Post some more sample data.It Is still unclear

Posted: Wed Jan 04, 2012 10:28 pm
by ray.wurlod
It's perfectly clear.

The next higher whole multiple of 3 than the generated value is required.

Divide by 3, use the Ceil() function to get the next higher integer, then multiply that by 3.

(You could use round_inf, too, if you had some other conversion function that needed to be applied.)

Posted: Wed Jan 04, 2012 10:31 pm
by nagarjuna
I think you can try with ceil & mod functions .