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.





      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.