9 Replies Latest reply: Jul 18, 2014 9:49 AM by PAUL YEO RSS

    Possible to make black ground color Green when Amount is negative ?

    PAUL YEO

      Hi All

       

       

      I have 2 table , each table have it correct color and wrong color :-

       

       

      Table 1 Sales color correct. But Payroll Exp color wrong.

      Table 2 Sales color Wrong. But Payroll Exp color Corect.

       

       

      I aware the issue is cause by the Amount , if Amount is positive it will

       

       

      Now For Table 3 , I Add a field = PLUS,display Green and if Amount is negative it will display Red.

      Because system does not know the Amount is sales or Expense.

       

       

      In order to let the system know the amount is sales or Expense , I add a new field = PLUS

       

       

      So i hope that the color will display as below behavious :-

       

       

      When  PLUS=P if Amount is positive make back ground color Green and Amount negative make color Red

      When  PLUS=N if Amount is positive make back ground color Red and Amount negative make color Green.

       

       

      Above is what i want , but i don't know how to start. Hope some one can advise me.

       

       

      Paul