change color for key figures?

[former_member245036]

Dear SAP Expert,

My expectation is to change color for key fig 'Dieu chinh so luong tien dieu hoa' when thí key fig has value different from 0. my psuedo code like this:

  If

     'Dieu chinh so luong tien dieu hoa' <> 0

      change default color of 'Dieu chinh so luong tien dieu hoa' into red color at detail location.

end if

Please show me how to implement this macro in sap snp

thanks so much

[rajkj · Accepted solution]

Pl check the following pseudo code -

Step 1: Iterations from initial through entire horizon

  If

     'Dieu chinh so luong tien dieu hoa' <> 0

      ROW['Dieu chinh so luong tien dieu hoa' ] (attributes) =

               CELL_BG( 6 );

else

      ROW['Dieu chinh so luong tien dieu hoa' ] (attributes) =

               CELL_BG( 0 );

end if

This code will color a specific cell red based on the condition check. If you wish to color entire row, then use ROW_BG macro function.

e.g.