COUNT and then SUM the result in an expression

[#1]

Hi,

How do I COUNT and then SUM the results of the COUNT on the same expression..

Something like SUM(COUNT(number))

Your soonest response will be highly appreciated, thanks.

Regards,

Mpho Musida

[datanibbler]

Hi Mpho,

from the information you have included, I'd say yes, exactly so 😉

[hic]

If you really want to make nested aggregation, you need to use Aggr(), and decide which aggregator to use in the middle step. E.g.

     Sum(Aggr(Count(ID), Customer))

You cannot just write Sum(Count( .. ))

HIC

[#4]

Exactly like you wrote it. Count will obviously count all the text values and numeric values within that field. Sum will then tell you how many there are in total.

Upload a sample document if there is a particular output you are trying to achieve and I will have a look at it for you

PS: Just realised who you are

Cheers,

Byron

[manojkulkarni]

Select Expression Total

[#6]

PS: Thanks

[MK_QSL]

To use more than one Aggr (i.e. Max, Min, SUM, COUNT, Avg etc.) you need to use AGGR function.

Max(AGGR(SUM(Sales),Customer))

This will give you Max Sales from all Customers...

[#8]

Thank you all