Re: Rounding up

[Booth Martin <booth@xxxxxxxxxxxx>]

I am thinking along these lines:  Is the multiplied answer greater that 
the %int?  If so, add 1 to the %int.  I haven't tested this, so be 
forewarned: look for the *doh*   :)

  Field 1 * Field 2 = Result1
  if  Result1 > %int(Result1)
  eval  Result1 = %int(Result1) + 1
*   else
*   eval  Result 1 = %int(Result1)
  endif

(The commented lines are just for a complete demonstration, but are 
redundant I believe.)

Lance Gillespie wrote:
> I have a situation where I need my results rounded up if they are not exact.
>
> As in:
> 2 * 1.01 = 3
> 2 * 1.50 = 3
> 2 * 1.51 = 4
>
> The source and target numbers are 7,0 and the factor is a constant.
>
> I thought: 
>
> target = %dech(source * 1.01) : 7 : 0)
>
> or maybe
>
> target = %dech(source * 1.01) : 9 : 2)
>
> would do it, but no joy.
>
> I suppose I could do the calcs twice with %dec, once to a 7,0 result and once to a 9,2 result
> (assuming %dec truncates) and then add one to the 7,0 result if the two are not equal, but
> I would rather not.
>
> Is there some way to force these calcs to round up if not exact?
>
> Thanks,
> Lance
>
>