Percentage of Total Set Analysis

[#1]

Hi All,

I need to work out the percentage using set analysis, but my understanding of set analysis isn't great.

Simplified example:

I have used set analysis to count the total enquiries sent to InsurerA; this gives me the following outcome:

Reason	No of Enquiries Sent	Percentage
Total	3	100%
No Quote	1	33.33%
Quoted & Won	1	33.33%
Quoted & Lost	1	33.33%

Expression behind No of Enquiries Sent:

=Sum({$<Insurer = {InsurerA}>}1)

Can anyone suggest an expression for the percentage column?

Thank you

[MK_QSL]

=Sum({$<Insurer = {InsurerA}>}1)/Sum(TOTAL {$<Insurer = {InsurerA}>}1)

or

=Sum({$<Insurer = {InsurerA}>}1)/Sum(ALL {$<Insurer = {InsurerA}>}1)

[PrashantSangle]

Sum({$<Insurer = {InsurerA}>}1)

/

Sum(Total{$<Insurer = {InsurerA}>}1)

Regards

[#4]

Thank you Manish and Max for your suggestions, but unfortunately they haven't worked.

I'm starting to think that there may be a problem with the way I have collated my data!

[MK_QSL · Accepted solution]

Try any of below and let me know ...

Count({<Insurer = {'InsurerA'}>}Insurer)/Count(TOTAL {<Insurer = {'InsurerA'}>}Insurer)

or

Count({<Insurer = {'InsurerA'}>}Insurer)/Count(ALL {<Insurer = {'InsurerA'}>}Insurer)

or

Count({<Insurer = {'InsurerA'}>}Insurer)/Count(TOTAL Insurer)

or

Count({<Insurer = {'InsurerA'}>}Insurer)/Count(ALL Insurer)

[#6]

Count({<Insurer = {'InsurerA'}>}Insurer)/Count(TOTAL {<Insurer = {'InsurerA'}>}Insurer)  - worked perfectly!

Thank you so much for your help!