7 Replies Latest reply: Jan 14, 2016 3:28 PM by Sangram Reddy RSS

    How Can I aggregate Count, Max and Sum

    Feras Alsuhaibani

      Hello Everyone!

       

      I'd like to ask if it is possible to aggregate Count, Max and Sum functions in one measure. I have been trying, but I have been getting an "expression error" and I don't know what is the issue. Here is my expression:

       

       

       

      Count({$<(TimeDiff  - ((max({$<  [ReqStatId] ={3}>} distinct TimeDiff/24  )) - ((Sum ( {$<  [ReqStatId] ={6}>} distinct ReqTime  )  - Sum ( {$<[ReqStatId] ={5}>} distinct ReqTime  )))) ) = {'>=0<24'}, ReqStatId= {3},  PackingId -={160}, CloseDate -= {null} >} distinct  ReqId)

       

       

      Wishing for your kind cooperation!

       

      Regards,