% of Count?

[knightwriter]

Hi All,

How do I formulate a percentage of the overall total for each of the columns in my straight table?

Kind regards

[sunny_talwar · Accepted solution]

May be this is what you are looking for:

Count(Field)/Count(Total Field)

[swuehl]

You can try enabling 'relative' option in your expression tab or use something like

=sum(Value) / sum(TOTAL Value)