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

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 your stylesheet Try:
TYPE=SUBTOTAL, COLUMN=AMOUNT, COLOR=RED,
WHEN=ST.AMOUNT LT 0,$