12 Replies Latest reply: May 17, 2012 9:27 AM by brandon breitling RSS

    Selecting a calculated dimension selects more than I want.

    brandon breitling

      I have a table with a calculated diminsion.  When I click on the diminsion of one record, it selects all the months and other fields that are used in the calculated dimension.  The calcualted dimension is an if statement that when true gives the value of a field. 

       

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

       

      When I click in the table, I only want the GL_Account_Number_Name_Balance_Sheet3 to be selected.  Is there away to do this?