Focal Point
Conditionally formating sub totals in sub footers

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/1011067992

September 18, 2008, 10:38 AM
<Developer>
Conditionally formating sub totals in sub footers
I am including subtotals in the sub footers, and would like to change the text color of the sub total depending on if the sub total is positive or negative.
What I seem to be seeing is that the condition seems to be acting upon the value of the last record prior to the sub footer, and not upon the sub total value.
For example if the sub total is positive, but the last value of the column was negative, the text color of the subtotal will be for negative. Is there a way around this?

Thanks
September 18, 2008, 10:50 AM
Prarie
Welcome - First - Please update your signature so we know what version you are on. Then provide us the code you are using in your stylesheet.

** Update signature
1) Logon to Focal Point and go into your complete profile.
2) Scroll down the page until you see the “Signature” field.
3) Fill in the signature you want to use. Here is a sample to model:


Prod: WebFOCUS 5.2.3 on Win 2K/IIS 6/ISAPI Mode
Test: WebFOCUS 7.1 on Win 2K/IIS 6/Weblogic 8.1/Servlet Mode

4) Once all changes are made/added, scroll down to the bottom of the page and click on the Submit button.


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
In your stylesheet Try:
TYPE=SUBTOTAL, COLUMN=AMOUNT, COLOR=RED,
WHEN=ST.AMOUNT LT 0,$


Pat
WF 7.6.8, AIX, AS400, NT
AS400 FOCUS, AIX FOCUS,
Oracle, DB2, JDE, Lotus Notes