I have a series of -SET variables that I'm trying to assign the format to:

-SET &TOTAL01= &RECORDS;
-SET &TOTAL01PCT= &RECORDS * .90;
-SET &TOTAL02PCT= &RECORDS * .10;

I noticed that when the value for &TOTAL01 is equal to 181, that the value of &TOTAL01PCT is 162, and the value of &TOTAL02PCT is 18. This does not total the original 181.

I think the problem is that 181 * .90 is actually 162.9, but the SET variable is actually returning 162.

Is there a way to apply formatting to the SET variable so that this will round correctly?

This message has been edited. Last edited by: ColdWhiteMilk,

Hi,

You can use the DMPRECISION setting before the calculation and to whatever the precision is.

  
SET DMPRECISION = 2
-RUN

Best Regards,

Jimmy Pang

quote:

SET DMPRECISION = 2
-RUN

Doesn't work for DM commands, this does:

  
-SET &TOTAL01   = 181;
-SET &TOTAL01PCT= (&TOTAL01 * .90) * 100;
-SET &TOTAL02PCT= (&TOTAL01 * .10) * 100;
-SET &TOTAL01_PCT = IF &TOTAL01PCT.LENGTH EQ 5 THEN EDIT(&TOTAL01PCT,'999.9') ELSE
-                   IF &TOTAL01PCT.LENGTH EQ 4 THEN EDIT(&TOTAL01PCT,'99.9')  ELSE
-                   IF &TOTAL01PCT.LENGTH EQ 3 THEN EDIT(&TOTAL01PCT,'9.9')   ELSE EDIT(&TOTAL01PCT,'.9');
-SET &TOTAL02_PCT = IF &TOTAL02PCT.LENGTH EQ 5 THEN EDIT(&TOTAL02PCT,'999.9') ELSE
-                   IF &TOTAL02PCT.LENGTH EQ 4 THEN EDIT(&TOTAL02PCT,'99.9')  ELSE
-                   IF &TOTAL02PCT.LENGTH EQ 3 THEN EDIT(&TOTAL02PCT,'9.9')   ELSE EDIT(&TOTAL01PCT,'.9');

-TYPE &TOTAL01_PCT
-TYPE &TOTAL02_PCT
-EXIT

quote:

Doesn't work for DM commands

??????

Then why does this -

SET DMPRECISION = 2
-RUN
-SET &TOTAL01   = 181;
-SET &TOTAL01PCT= &TOTAL01 * 0.90;
-SET &TOTAL02PCT= &TOTAL01 * 0.10;
-? &TOTAL

give this

 CURRENTLY DEFINED & VARIABLES STARTING WITH 'TOTAL':
 &TOTAL01      = 181
 &TOTAL01PCT   = 162.9
 &TOTAL02PCT   = 18.1

If the requirement is to have "correctly" rounded integers then I would be inclined to force the rounding and go with this -

-SET &TOTAL01   = 181;
-SET &TOTAL01PCT= (&TOTAL01 * 0.90) + 0.5;
-SET &TOTAL02PCT= (&TOTAL01 * 0.10) + 0.5;
-? &TOTAL

Don't forget that if you used a multiplier of .5 in this example then you would get 91 and 91 so you need to know the data you are handling and code accordingly.

T

Hi,

Seems to work for me

  

-SET &TOTAL01   = 181; 
-SET &TOTAL01PCT= &TOTAL01 * .90;
-TYPE &TOTAL01PCT

SET DMPRECISION = 2
-RUN

-SET &TOTAL01PCT= &TOTAL01 * .90;
-TYPE &TOTAL01PCT

My output is
162
162.9

The first output is before the DMPRECISION is set (default is OFF)

Bst Regards,

Jimmy Pang

Jimmy,

You are absolutely correct. I used it above the 1st -SET, not the 2nd. Much cleaner/easier!!

Thanks!

What if I want the 162.9 to round up to 163?

Hi,

You can try DMPRECISION = 0

Best Regards,

Jimmy Pang

Thank you. This appears to be working.

You all are the best!