Announcements
cancel
Showing results for
Did you mean:
Creator II

## % Expression

I have at pivot table that I'm looking to add a % to but it's not a forward as x/y*100. I have -

Name     Matched          Number     Matched %     Unmatched %

1             Matched          3

1             Matched          6

1             Matched          7

1             Matched          3

1             Unmatched      4

2             Matched          4

2             Matched          5

So, for Name 1 I want the % for Matched and Unmatched.  The sum for matched would be 3/(6+7+3)=18.75% but how do i do that with the fields above?

Unmatched would be 4/4=100%

1 Solution

Accepted Solutions
MVP

Maybe this

Sum({<Matched = {'Matched'}>} Number)/Sum({<Matched = {'Matched'}>} TOTAL <Name> Number)

4 Replies
MVP

Maybe this

Sum({<Matched = {'Matched'}>} Number)/Sum({<Matched = {'Matched'}>} TOTAL <Name> Number)

Creator II
Author

Thank you

MVP

I had a typo in my expression... which I have fixed now... but I guess you already spotted it on your end

Creator II
Author

Yes i did but thank you anyway.

Community Browser