Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to Calculate Percentages of Male / Females based on certain criteria as listed below under each Lead, I tried the following but it calculates the % considering the Grand total , I need a formula in Expression to calculate this percentage considering the Total of Male/Females under each Lead rather than the Grand total.
Count({1<[End Date] = {">=$(=Date(Today(), 'DD/MM/YYYY'))","-"}>}distinct [UID])
/
(Count({1<[End Date] = {">=$(=Date(Today(), 'DD/MM/YYYY'))","-"}>}distinct TOTAL [UID])-(Count({<[Employee ID] = {"-"}>}distinct TOTAL [UID])))
Lead | Gender | Count | % of Total | Need this Correct % of Total |
A | Male | 73 | 8% | 68.22% |
Female | 34 | 4% | 31.78% | |
B | Male | 9 | 1% | 69.23% |
Female | 4 | 0% | 30.77% | |
C | Male | 54 | 6% | 79.41% |
Female | 14 | 2% | 20.59% | |
D | Male | 106 | 12% | 85.48% |
Female | 18 | 2% | 14.52% | |
E | Male | 336 | 39% | 82.56% |
Female | 71 | 8% | 17.44% | |
F | Male | 40 | 5% | 75.47% |
Female | 13 | 1% | 24.53% | |
G | Male | 16 | 2% | 100.00% |
H | Male | 20 | 2% | 83.33% |
Female | 4 | 0% | 16.67% | |
I | Male | 40 | 5% | 72.73% |
Female | 15 | 2% | 27.27% | |
867 | 100% |
HI,
Include Lead dimension inside like below
=(Count(distinct ID)/ Count( TOTAL <Lead> DISTINCT ID) ) *100
Your expression :
Count({1<[End Date] = {">=$(=Date(Today(), 'DD/MM/YYYY'))","-"}>}distinct [UID])
/
(Count({1<[End Date] = {">=$(=Date(Today(), 'DD/MM/YYYY'))","-"}>}TOTAL <Lead> distinct [UID])-(Count({<[Employee ID] = {"-"}>} TOTAL <Lead> distinct [UID])))
Thanks,
Sasi
Thank you Sasi, but it doesn't seem to be working.
Would you be able share some sample data??