0 Replies Latest reply: May 16, 2012 12:49 PM by brandon breitling RSS

    How to make complicated calculated dimension included into expression

    brandon breitling

      Here is my calculated dimension:

       

      =if((BLMonth1<=CurrentDocumentMonth3 or BLYear<"CurrentDocumentYear" or BLMonth=0) and BLYear<="CurrentDocumentYear",GL_Account_Number_Name_Balance_Sheet3)

       

      Here is my expression:

      sum({ $<  balcode3={'ACTUAL'},

      [code3]={'RBIACCT'}

                   >}Tot3)

       

      Is there anyway to have my dimension just be GL_Account_Number_Name_Balance_Sheet3 and have the expression contain all the logic for the calculated dimension?