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