5 Replies Latest reply: Oct 6, 2011 12:36 PM by MARCO HADIYANTO RSS

    background color for YTD Actual vs Budget

    MARCO HADIYANTO

      Hi..

       

      I have a problem with background color of chart.

      Case likein finance controlling, in P&L Trends’ sheet, actual vs budget chart. wewant the background color if actual >budget is green, and if actual <budget is red. It’s already done .

      Expression P&L Trends:

      Actual : sum({<ReportTypeName={'Profitand Loss'},AccountName={'Revenue'}>} Actual)

      Budget : sum({<ReportTypeName={'Profitand Loss'},AccountName={'Revenue'}>} Budget)

       

      BackgroundColor for Actual vs Budget :

      if(sum({<ReportTypeName={'Profit and Loss'},AccountName={'Revenue'}>}Actual)>

      sum({<ReportTypeName={'Profit and Loss'},AccountName={'Revenue'}>}Budget),

      RGB(0,255,0),

      if(sum({<ReportTypeName={'Profit and Loss'},AccountName={'Revenue'}>}Actual)<

      sum({<ReportTypeName={'Profit and Loss'},AccountName={'Revenue'}>}Budget),

      RGB(255,170,170)
      ,RGB(179,179,179))))

       

      But i want to show P&L Trends in YTD which is the expression using full accumulation,I can’t use the same background color expression, because the value of everymonth it’s increase.

      How to setthe color for this YTD?

       

       


      Regards,

       

      Marco

        • background color for YTD Actual vs Budget

          Hi Marco,

           

          I think it is not possible to do what you want.

           

          Another solution is to make a YTD flag in your calendar table and use this in the expression where you set the color.

           

          Succes, Halmar

            • background color for YTD Actual vs Budget
              MARCO HADIYANTO


              Halmar Heijnen wrote:

               

              Hi Marco,

               

              I think it is not possible to do what you want.

               

              Another solution is to make a YTD flag in your calendar table and use this in the expression where you set the color.

               

              Succes, Halmar

              Hi Halmar,

               

              i don't get it what you mean to make a YTD flag. have you ever facing this problem before? i need your advice..

               

              thanks,,

               

              Marco

            • background color for YTD Actual vs Budget
              Anand Chouhan

              Hi,

               

               

              I think you do correct what problem you are facing try this code

               

              if(sum({<ReportTypeName={'Profit and Loss'},AccountName={'Revenue'}>}Actual)>

                 sum({<ReportTypeName={'Profit and Loss'},AccountName={'Revenue'}>}Budget),

                 RGB(0,255,0),

              if(sum({<ReportTypeName={'Profit and Loss'},AccountName={'Revenue'}>}Actual)<

                 sum({<ReportTypeName={'Profit and Loss'},AccountName={'Revenue'}>}Budget),

                 RGB(255,170,170)

                ,RGB(179,179,179)))

               

              Rgds

              Anand

                • background color for YTD Actual vs Budget

                  Marco,

                   

                  Are the expressions that determine Actual and Budget also calculated in the same object you want to modify the background of?  If so, then you could just use the expression label name and say something like... if([Actual] >= [Budget], rgb(0,255,0),rgb(255,0,0))

                   

                  SJ

                    • background color for YTD Actual vs Budget
                      MARCO HADIYANTO

                      shanejvv wrote:

                       

                      Marco,

                       

                      Are the expressions that determine Actual and Budget also calculated in the same object you want to modify the background of?  If so, then you could just use the expression label name and say something like... if([Actual] >= [Budget], rgb(0,255,0),rgb(255,0,0))

                       

                      SJ

                      Hi Shanejw,

                       

                      i want to get value of actual and budget in accumulation value for each month and then to compare it, to put the color.

                       

                      i already try to use the expression label. it's still the same..

                      any idea?

                       

                      thanks,

                       

                      Marco