topic Re: How Can I aggregate Count, Max and Sum in App Development

How Can I aggregate Count, Max and Sum

Anonymous — Wed, 13 Jan 2016 09:45:12 GMT

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,

Re: How Can I aggregate Count, Max and Sum

sunny_talwar — Wed, 13 Jan 2016 13:31:58 GMT

Can you post a screenshot of the expression from where you are using it?

Re: How Can I aggregate Count, Max and Sum

ogster1974 — Wed, 13 Jan 2016 13:33:00 GMT

=AGGR(<YOUR EXPRESSION>, <YOUR GROUP BY VALUE>)

Re: How Can I aggregate Count, Max and Sum

Anonymous — Thu, 14 Jan 2016 16:59:28 GMT

Hello,

Can you give an example please, as I tried what you wrote and it is syntax free however the result is always zero.

Re: How Can I aggregate Count, Max and Sum

Anonymous — Thu, 14 Jan 2016 16:59:56 GMT

I am using this expression in a KPI widget.

Re: How Can I aggregate Count, Max and Sum

reddy-s — Thu, 14 Jan 2016 17:18:08 GMT

Hi Freras,

Use this:

aggr(Sum(X),<Field1>,<Field2>,......)

The field list acts as a group by and the sum function performs the aggregation

Re: How Can I aggregate Count, Max and Sum

Anonymous — Thu, 14 Jan 2016 17:39:02 GMT

Thanks Sangram!

Sangram, I am trying to have a count, max and sum functions in the same expression:

here is the idea I want to reach:

Count (Max(x) - (y - z) <=24 && a = 1 && b = 2)

I hope it is clear now .

Re: How Can I aggregate Count, Max and Sum

reddy-s — Thu, 14 Jan 2016 20:28:25 GMT

Hi Feras,

Is it possible to attach a sample qvf , so that it will be easy to solve the issue?

Thanks,

Sangram Reddy.