Hi Experts
I need to calculate how many Projects of each company moved from Phase 1 to Phase 3 as a Percentage. See sample dats below
in the explain below for company ABC Phase 1 = 17 Projects and Phase 2 = 8 Projects hence 47 of the applications moved to the second phase ie. Phase 2 , then 2 out of 8 projects move to final phase 3 = 25%.
Co Name | Phase 1 | Phase 2 | Phase 3 |
ABC | 17 | 8 | 2 |
SSF | 16 | 11 | 4 |
DDCW | 11 | 9 | 5 |
Solved! Go to Solution.
Hi,
i'm unsure on the explanation are you just looking for the calculation to work out between phase 2 and 3 to give you the 25% figure:
if so
Hi,
i'm unsure on the explanation are you just looking for the calculation to work out between phase 2 and 3 to give you the 25% figure:
if so
User | Count |
---|---|
143 | |
85 | |
64 | |
60 | |
57 |
User | Count |
---|---|
211 | |
109 | |
89 | |
76 | |
74 |