1 Reply Latest reply: Jun 21, 2012 5:46 PM by brandon breitling RSS

    Calculated Dimension moved to expression

    brandon breitling

      Hi Community,

       

      I have a graph with two calculated dimensions and an expression. How would I change the calculated dimensions to plain dimensions of GL_Account_Number_Name_Balance_Sheet3 and Department_Number_Name3?

       

      Here are the calculated dimensions:

      =if(match(QB22,el2),GL_Account_Number_Name_Balance_Sheet3)

      =if(match(QB33,el3),Department_Number_Name3)

       

      Here is the expression:

      sum({ $< QBbalcode={'DLHOURS'},

      LinkYear={$(=Only("CurrentDocumentYear"))},

      LinkMonth=CurrentDocumentMonth3,

      [code]={'RBIACCT'}

      >}full_value)

       

      I've tried a lot of different things but can't get the same totals. Any ideas? The reason I want to move away from calculated dimensions is that when you click on one it selects all the fields included in the calculation.