In WebFOCUS 5.2 does anyone have a way to conditionally format a field by changing the actual format. What I want is this:

table file car
print price and compute
perc/d5.1% = if country eq 'france' then .... else
whole/d5 = if country ne 'france' then ....

anyway, you get the idea - I either want a whole number to display or a fraction that is a percentage to display. I know the above is not correct syntax just trying to give the idea that in the same column either a whole or fraction.

Do I have to use FRL to achieve this?

Thanks in advance,
Vivian Perlmutter
www.aviter.com
vivian@aviter.com

Try this:


TABLE FILE CAR
PRINT
DEALER_COST
RETAIL_COST
COMPUTE WHOLE = RETAIL_COST - DEALER_COST; NOPRINT
COMPUTE PCT = 100 * DEALER_COST / RETAIL_COST; NOPRINT
COMPUTE MYVAL/A10 = IF COUNTRY EQ 'ITALY'
THEN FTOA(PCT, '(D5.2%)', MYVAL)
ELSE FTOA(WHOLE, '(D7)', MYVAL);
BY CAR
BY MODEL
BY COUNTRY
END

The major caveat is that MYVAL is an alpha field... meaning you can't aggregate it. Although I'm not sure you'd want to aggregate whole numbers with percents anyway!

I hope this helps.
-Michael

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

Thank you, thank you,

With a little tweaking to match my code, it worked perfectly!

Vivian Perlmutter