Hi Bruno, and thanks for the reply. Now it works!!! The error disappear, so this is the solution 🙂 Thanks for your support Now I have another problem. I think that it should be useful to open a new request but..., I try to explain here: I have to change the color of the cell pct_col comparing that with the total pct_col in the row: This is the output I would have to have: ... pct_col1 .... pct_col2 ... pct_col_TOT ... 0,15 .... 0,99 ... 0,52 ... 0,62 .... 0,20 ... 0,43 ... 0,77 .... 0,60 ... 0,69 And the goal is to color the pct_col cells using the following rule: if pct_col1 < pct_col_tot * 0,80 => then turns in YELLOW if pct_col1 > pct_col_tot * 1,20 => then turns in BLUE but.... How I can estimate the pct_col_tot (the total "pctsum" in the analysis define) for each row? I try this: compute pct_col;
if _C6_ not in( 0,. )
then
do;
if _C6_ < ( pct_col_tot*0.8 )
then
call define ("_C6_", "style", "style=[background=<yellow>" );
else
if _C6_ >= ( pct_col_tot*1.2 )
then
call define ("_C6_", "style", "style=[background=<blue>" );
end;
if _C11_ not in( 0,. )
then
do;
if _C11_ < ( tot_ssr*0.9 )
then
call define ("_C11_", "style", "style=[background=CX00FF00]" );
else
if _C11_ >= ( tot_ssr*1.1 )
then
call define ("_C11_", "style", "style=[background=CXFF0000]" );
end;
endcompute;
compute before;
num = _C3_ + _C8_ ;
den = _C2_ + _C7_ ;
pct_col_tot = num / den * 100;
endcompute; but the calculation use the pct_col_tot of the report, not the row's one. Any help? Once again, thanks Bruno 🙂
... View more
