3 Replies Latest reply: Jun 10, 2014 9:52 AM by Jacob Kean RSS

    Background color depending on another results


      Hi,

       

      I need to use a formula that changes the background of the cell depending on the result of the expression (i am coparing between the Forecast and the budget).

       

      If the forecast is >= Budget then green else red. But this doesn't work for me.

       

      Can you help me to correct this expression.

       

      Please find attached my application.

       

      Thanks

        • Re: Background color depending on another results

          Hello Imen,

           

          In your background color expression:

           

          sum({ <YEAR_EXERCISE ={"= $(v_SelectedYear)"},SPQVC_ORDER={'V01'},EXERCISE ={'BUDGET'}>} Amount)

           

          Returns 0 for every value that is not associated with EXERCISE = 'BUDGET'.

           

          So I replaced the above with your v_Budget, which is equal to 21,579,268.37.

           

          The problem with this is that it is greater than every single one of your act/fcst.

           

          This might be something you can fix in your load script. The problem is that your other Exercises cannot be compared to your Budget Exercises.