6 Replies Latest reply: May 7, 2014 11:43 AM by Michael Reagan RSS

    Expression Attribute Background Color problem

    Michael Reagan

      Hello All-

       

      I have a stacked bar chart that represents an Opportunity Pipeline. The sections of the bars are sales stages for the opportunities and the dimension is year-quarter.

       

      4-1-2014 3-54-01 PM.jpg

       

      The expression is fairly simple:

       

      Sum ({<Opportunities.StageGroup = {'Pending','Committed'}

      ,FiscalYearName =

      ,Calendar.RelativeFiscalQuarter = {

             'Current Quarter',

             'Current Quarter + 1',

             'Current Quarter + 2',

             'Current Quarter + 3',

             'Current Quarter + 4'}

        >} Opportunities.Amount)

       

      In the Expression Attribute Background Color, I have the following expression:

       

      =If(Opportunities.StageNumber = '5', $(vStg5Color),

        If(Opportunities.StageNumber = '4B', $(vStg4BColor),

        If(Opportunities.StageNumber = '4A', $(vStg4AColor),

        If(Opportunities.StageNumber = '3', $(vStg3Color),

        If(Opportunities.StageNumber = '2', $(vStg2Color),

        If(Opportunities.StageNumber = '1', $(vStg1Color)))))))

       

      The variables are in the form of:

       

      =rgb(176,202,142)

       

      Unfortunately, if I filter on a year (FiscalYearName) outside of the set analysis, it wrecks the colors (this has FY13 selected):

       

      4-1-2014 3-58-09 PM.jpg

       

      I've tried with and without the '=' in the variables and also by using the RGB directly in the If statement in the background color.

       

      Any thoughts on how I can fix it?

       

      Thanks in advance!

       

      Mike

      www.fortunecookiebi.com