9 Replies Latest reply: Dec 25, 2017 7:19 AM by pradosh thakur RSS

    How to calculate Average and Max with Count Expression

    Shahzad Ahsan

      Hi Everyone

      I want to calculate average and Max for this expression

      My Measure is like this:

       

      Count(if(TRANSACTION_DATE >= today()-7 and TRANSACTION_TYPE='RECEIVE', TRANSACTION_ID))

       

      I want to calculate Average and Max.

      Please help me.