I need to format numbers differently in the same column. I'd like the numbers at the top of the report to be integer and the numbers at the bottom, in grey, to be % with one decimal.

Is there any way to format them differently?

We're using version 7703.

Thanks.

This message has been edited. Last edited by: <Kathryn Henning>,

Look for "Applying Dynamically Formatted Virtual Fields to Report Columns" in the documentation, described in the GUI section of the docs, or here:

Creating Reports With WebFOCUS Language > Creating Temporary Fields > Defining a Virtual Field > Applying Dynamically Formatted Virtual Fields to Report Columns

Hi Deej, You can do it in at least one of two ways. Use a Subfoot or use FML with Recaps. There may be other ways also.

Thanks for the suggestions, I'll take a look.

Sorry for the late reply, my computer went down shortly after I posted this and I'm just now getting back up and running.

Thanks,

DJ

 
DEFINE FILE CAR
NEWFMT/A8              = IF COUNTRY EQ 'ENGLAND' THEN 'D15M'  ELSE 'D15.2'  ;
END
TABLE FILE CAR
LIST COUNTRY DEALER_COST/NEWFMT 
END 

what jimbo says.

jimbo, I tried applying your suggestion to my report and I'm almost there, just need a tweak but I'm not sure how to tweak it.

My original report code shows this:

-SET &RANDOM = RDUNIF(D5) * RDUNIF(D5) * 10000;
TABLE FILE FLOORING_WARRANTY_MONTHLY_SCORECARD_TBL

SUM
METRIC NOPRINT
ACTUAL/P6.1BCS AS 'Actual'

BY METRIC_SEQUENCE NOPRINT
BY METRIC AS ''
ACROSS HIGHEST YEARMONTH AS ''



And when I tried to apply your code to my report:

DEFINE FILE FLOORING_WARRANTY_MONTHLY_SCORECARD_TBL
ACTUAL/A8 = IF METRIC EQ '% Opened New Construction' THEN 'P2.1BCS%' ELSE IF METRIC EQ '% Opened Retail' THEN 'P2.1BCS%' ELSE IF METRIC EQ '% Opened Commercial' THEN 'P2.1BCS%' ELSE IF METRIC EQ '% Opened Other' THEN 'P2.1BCS%' ELSE 'P6C' ;
END

-SET &RANDOM = RDUNIF(D5) * RDUNIF(D5) * 10000;
TABLE FILE FLOORING_WARRANTY_MONTHLY_SCORECARD_TBL

SUM
METRIC NOPRINT
ACTUAL

BY METRIC_SEQUENCE NOPRINT
BY METRIC AS ''
ACROSS HIGHEST YEARMONTH AS ''




I know I'm close, but what do I need to change/add?

Not sure why my pictures aren't showing up. FRUSTRATING!

Got it!!

DEFINE FILE FLOORING_WARRANTY_MONTHLY_SCORECARD_TBL
NEWFMT/A8 = IF METRIC EQ '% Opened New Construction' THEN 'P6.1BCS%' ELSE IF METRIC EQ '% Opened Retail' THEN 'P6.1BCS%' ELSE IF METRIC EQ '% Opened Commercial' THEN 'P6.1BCS%' ELSE IF METRIC EQ '% Opened Other' THEN 'P6.1BCS%' ELSE 'P6C' ;
END

-SET &RANDOM = RDUNIF(D5) * RDUNIF(D5) * 10000;
TABLE FILE FLOORING_WARRANTY_MONTHLY_SCORECARD_TBL
SUM

METRIC NOPRINT


ACTUAL/NEWFMT AS 'Actual'

BY METRIC_SEQUENCE NOPRINT
BY METRIC AS ''
ACROSS HIGHEST YEARMONTH AS ''

Quite often tinypic is blocked by the server. In my company it's blocked as a "Adult/Mature Content;Intimate Apparel/Swimsuit" site.

So I take it they are showing up in my post for everyone else?

Thanks again for all of the responses.

Nope - no pictures here - and I allow ALL content.