Hello all,

Can anyone tell why:

COMPUTE Total_AMT/P16.2C = (Sales * COMMISION / 100);
AS 'COMM-AMT'

works fine.

But
COMPUTE Total_AMT/P16.2C = (Sales * COMMISION / -100);
AS 'COMM-AMT'

Returns the error msg:
0(FOC260) AN OPERATION IS MISSING AN ARGUMENT

Thanks to all!

Webfocus 5.3.2 soon 7.1.4 IBM mainframe

Try:

COMPUTE Total_AMT/P16.2C = (Sales * COMMISION / (-100));
AS 'COMM-AMT'

Good Luck,
P

COMPUTE Total_AMT/P16.2C = -1*(Sales * COMMISION / 100);
AS 'COMM-AMT'

or this..

COMPUTE Total_AMT/P16.2C = (-1) * (Sales * COMMISION / 100);
AS 'COMM-AMT'

Goooooooooood day !!
Sandeep Mamidenna

You can not have two operators (/-) together, and you can separate them by adding ()around the negative number.

Agreed. No two operators together...
Try this:
COMPUTE Total_AMT/P16.2C = ((Sales * COMMISION / 100) * -1); AS 'COMM-AMT'
Also be careful if mixing and matching case - especially if in the Unix world.

Ira....

Hello All,

I went with this solution and it works file:

COMPUTE Total_comm/P16.2C = -1*(Sales * COMMISSION_PCT / 100); AS 'COMMISSION-AMT'

Thanks!

nice to know
I just wonder why you have this computed field as a Packed format instead of Decimal.

What is the main difference to use packed or decimal?

Can someone give me a reason?

It has to do with the way rounding happens and the depth of decimal carrying.
packed is best for monetary figures.

Frank,

Basically (and I know there is more to this but I'm keeping it basic),

D format retains all decimal positions as it is passed through the various processes so even when you have D20.2, if you put 3.1415927 into it it will still retain the full value in any calculations etc. but in display it will only show 3.14. Add five of the same together and you should get 15.71 and not 15.70.

P or packed decimal, as Susannah states, is best for monetary values if you are working to a spcific number of decimals. Place 3.1415927 into a P20.2 and it will use 3.14 and lose any precision you might want.

T

Tony A. Gret reply; I could not have put it better myself.