I am creating a report that needs to use P16.5% and include the (+/-) sign in front. I do not want to Concantenant that is use '||' then the field will have to change to an Alpha.

Any help would be appreciated.

By defualt WebFocus displays - signs for negative values
for example
TABLE FILE CAR
PRINT
'BODY.DEALER_COST'
'BODY.RETAIL_COST'
COMPUTE NEGP/P16.6% = ((DEALER_COST-RETAIL_COST)/RETAIL_COST)*100;
END

Which will display -xx.xx%

If you want it to display as xx.xx-%

try

TABLE FILE CAR
PRINT
DEALER_COST
RETAIL_COST
COMPUTE NEGP/P16.6%- = ((DEALER_COST-RETAIL_COST)/RETAIL_COST)*100;
END

I know how to use the "%" in the format. My problem is that I am in Batch MVS 7.1.1 and creating an Output file format EXL2K that when I use the "%" it seems it changes to absolute value.

Any thoughts?

In WebFOCUS 5.3.2 for Windows, the Excel 2000 format displays correctly.

TABLE FILE CAR
PRINT
DEALER_COST NOPRINT
RETAIL_COST NOPRINT
COMPUTE NEGP/P16.6% = ((DEALER_COST-RETAIL_COST)/RETAIL_COST)*100;
ON TABLE PCHOLD FORMAT EXL2K
END

-16.343771%
-17.026166%
-16.302521%
-16.342784%

At present I am creating a Dynamic JCl from WebFocus 5.2.6 that is going to MVS Focus 7.1.1 which creates an Output File format EXL2K, Which intern is being e-mailed to multiple people.