6 Replies Latest reply: Dec 7, 2012 4:23 AM by Vishnu S RSS

    Help me with this set expression

      Hi There,

       

      I have a calculated dimension in table chart as follows.

       

      =aggr(count(VISIT_MAIN),DRG_BL_VALUE)

       

       

      In need to include a condition in that dimension to restrict it to those Discharge_Date with values only between the two calender object selections for start date and end date (vDMin and vDMax respectively)

       

      That is, in the above aggr expression, I have to include this condition

       

       

      Discharge_Date>=vDMin and Discharge_Date<=vDMax

       

       

      I had given like this : =aggr(count( ( {$<Discharge_Date={">=$(vDMin)<=$(vDMax)"}>} VISIT_MAIN),DRG_BL_VALUE) , but it was not helpful.


      Please help me with this.

       

      Thanks

      Sircute