6 Replies Latest reply: Jul 6, 2010 12:32 AM by tatarjar RSS

    Change text color...if the value of the first column is null, it failed to work??

      Hi all,I am trying to change text color. But found that if the value of the first column is null, it failed to work.

      I find the solution from the other forum and I do follow the sugestion uncheck "suppress zero values". But it's still not work in my case.

      I use this code in set text color:

      if((mid(FICO_NodeGroup,1,3)='TTL') or (FICO_NodeGroup='STTL')

      And I have two expression:

      1)

      IF(ISNULL(SUM({$<$(eFICO_Indicator_Actual)>} FICO_AMOUNT_CY/vFICO_Format))
      ,0,
      SUM({$<$(eFICO_Indicator_Actual)>} FICO_AMOUNT_CY/vFICO_Format))

      2)

      IF(BEFORE(SUM({$<$(eFICO_BaseNode),$(eFICO_Indicator_Actual)>} TOTAL<FICO.Curr_Period,FICO_BRANCH_NAME,FICO_DIST_CHANNEL_NAME,PART_HIERARCHY4_NAME,FICO_PROFIT_CCTR_NAME,PRCTR_Grp,FICO_COST_CCTR_NAME,CCTR_Grp> FICO_AMOUNT_CY/vFICO_Format),0)=0
      ,0,
      BEFORE(SUM({$<$(eFICO_Indicator_Actual)>} FICO_AMOUNT_CY/vFICO_Format),0)
      /BEFORE(SUM({$<$(eFICO_BaseNode),$(eFICO_Indicator_Actual)>} TOTAL<FICO.Curr_Period,FICO_BRANCH_NAME,FICO_DIST_CHANNEL_NAME,PART_HIERARCHY4_NAME,FICO_PROFIT_CCTR_NAME,PRCTR_Grp,FICO_COST_CCTR_NAME,CCTR_Grp> FICO_AMOUNT_CY/vFICO_Format),0))

       

      Am I do something wrong?

      Could anyone suggest the solution for me?

      Regards.