Re: Question about DIV and MVR

Ala, Michael A wrote:

Question about MVR operation how should the Div Result be Defined with
or without decimals

Same for Remainder Field

I have come up with various results with different formatting and want
to know best/Common practices

Example 60/84 = .714 on a calculator but one of programmers was not
getting this result with the move remainder when Both Fields were
defined with 3 decimal Places

MVR doesn't give you the decimal part of a non-integer quotient, it gives the remainder. Integer division is defined by the formula:
a = qb + r where 0 <= r < b
In your case, a = 60, b=84, so q must be 0 and r must be 64.

Also, you should consider using the %div() and %rem() built-in functions instead of DIV and MVR.

Perhaps you really want to
EVAL ratio = field1 / field2?
EVAL decimalPart = ratio - %div(field1:field2)

or, you could use DIV twice, once with a result field that has decimals (a) and one that doesn't (b). Then, a - b should give you the decimal part of the result.