Forum Discussion
ConnieMaldonado
Responsive Resident
Responsive ResidentCalculate Percentage using SUM based on EE ID and Week Ending Date
Hello - I think this is a fairly easy thing, but I can't figure it out. I'm trying to calculate work order mix percentages for Install work orders, Service work orders, and Upgrade work orders BY TECH (EE Number) and BY WEEK ENDING date. I have the number of install, service, and upgrade work orders on the record, and I created a column to calculate the total. The issue is if I calcualte the percentage using a divide, the percentage gets summed. I need to create a measure to group by tech and week ending date, but I'm not sure how to do it. I want to display the resulys by Tech and Week Ending Date.
SERVICE MIX INSTALL % = DIVIDE(RevenueByTech[INSTALL], RevenueByTech[SERVICE MIX Total])
Any help would be appreciated!!
| RDO Name | Site Manager | Location | LOB | Tech Name | EE Number | Hire Date | Term Date | Status | Week Ending | Average Weekly Revenue | INSTALL | SERVICE | UPGRADE | SERVICE MIX Total |
| RDO 1 | SM 1 | LOC 1 | LOB 1 | John Smith | 123456 | 8/31/15 | Active | 10/23/20 | $5,000 | 14 | 19 | 7 | 40 | |
| RDO 1 | SM 1 | LOC 1 | LOB 1 | John Smith | 123456 | 8/31/15 | Active | 10/23/20 | $4,000 | 13 | 14 | 8 | 35 | |
| RDO 1 | SM 1 | LOC 1 | LOB 1 | John Smith | 123456 | 8/31/15 | Active | 10/30/20 | $2,000 | 16 | 19 | 4 | 39 | |
| RDO 1 | SM 1 | LOC 1 | LOB 1 | John Smith | 123456 | 8/31/15 | Active | 10/30/20 | $3,500 | 17 | 20 | 6 | 43 | |
| RDO 1 | SM 1 | LOC 1 | LOB 1 | John Smith | 123456 | 8/31/15 | Active | 11/6/20 | $3,000 | 20 | 12 | 5 | 37 | |
| RDO 1 | SM 1 | LOC 1 | LOB 1 | John Smith | 123456 | 8/31/15 | Active | 11/6/20 | $4,000 | 15 | 20 | 3 | 38 |
I believe I have this working. I used the following:
SVCMIX Install % =DIVIDE (CALCULATE(SUM(RevenueByTech[INSTALL])) ,CALCULATE(SUM(RevenueByTech[SVCMIX Total])))
1 Reply
- ConnieMaldonado
I believe I have this working. I used the following:
SVCMIX Install % =DIVIDE (CALCULATE(SUM(RevenueByTech[INSTALL])) ,CALCULATE(SUM(RevenueByTech[SVCMIX Total])))