4 Replies Latest reply: Nov 27, 2013 9:17 AM by Nicole Smith RSS

    Max date in dimension in a piro table


      hallo everybody,

       

      I need your help for a set dimension in a dimension. I need the last date for a special criteria as dimension.

       

      I use the max function but this doesnot work.

       

      Can anybody help me.

       

      One sample for my formula:

       

       

       

      if(INVT_TRANS_DETAIL.TRAN_CODE='SPRECEIVE', max(INVT_TRANS_DETAIL.TRAN_DATE))

       

      Thanks and greetings Sven