Focal Point
Conditional styling using Average

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

December 14, 2007, 05:56 AM
Deepa497
Conditional styling using Average
Hi
I have following code:

.....
TABLE FILE XYZ
SUM
A AS 'MTD '
b AS 'YTD '
BY TTL NOPRINT
BY Temp NOPRINT
BY ST_PROV_C NOPRINT
BY YR_I NOPRINT
BY MO_I NOPRINT
BY CURR_PROTO_GRP_N
BY CURR_PROTO_T
BY REF_CO_LOC_I
BY HIER_LVL_4_N
ACROSS Util_Type AS ''
ON TTL SUBTOTAL
AVE. A
AVE. B AS ' Average Usage'
ON Temp SUBTOTAL
SUM. A
SUM. B AS 'Total Usage'
ON CURR_PROTO_GRP_N SUBTOTAL
AVE. A
AVE. B AS ' Average Usage'

......

Now in the conditional styling for the columns MO_USE_Q and MO_YTD_USE_Q I want to do some kind of coloring based on the formula

(store type average usage - store actual usage) divided by (store type average usage)) * 100 is less than -10, then color red ....

NOTE:
a) store type average usage is the average fouund based on CURR_PROTO_GRP_N
b) store actual usage for different columns is sum ( A ), sum(B) for different values of Util_Type(across value)

My question is how to capture the average value?

Thanks
Deep


WebFocus 7.1.4, Windows Server 2005 , HTML/EXL/PDF
December 14, 2007, 07:36 AM
GamP
I think you accidentally duplicated this entry.
Take a look at the other one, simply called 'Conditional Styling'.


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988