Help with Expression

[aarohipatel]

Hi ,

Field Name: ID

Expression needed: Count(ID) / Sum[Count (ID)]

Not able to get this expression work. Can you please help me with this?

Thank you

[maxgro]

I think you need a nested aggregation

Pitfalls of the Aggr function

Count(ID)

/

Sum(   aggr(Count (ID), field1, field2, ....)   )

Maybe you can post your .qvw

[sunny_talwar · Accepted solution]

This?

Count(ID)/Count(TOTAL ID)