Good day,
Please assist me with this formula.
I have a table showing the number of orders we create and give feedback on from our desktops and phone app. The order can be for Preventive or Corrective services
Columns are as follows;
| Order number | Create Date | Compl Date | Corr / Preven | Create Total Qty | FB Total Qty | Create App | FB App |
| 123456 | 01/05/2019 | 10/05/2019 | Corrective | 1 | 1 | 1 | 1 |
| 123567 | 01/06/2019 | 17/06/2019 | Corrective | 1 | 1 | 0 | 0 |
| 134567 | 10/04/2019 | 31/04/2019 | Preventive | 1 | 1 | 1 | 1 |
| 135698 | 15/05/2019 | 21/05/2019 | Preventive | 1 | 1 | 0 | 0 |
| 156897 | 01/06/2019 | 10/06/2019 | Preventive | 1 | 1 | 1 | 0 |
| 149637 | 15/06/2019 | 17/06/2019 | Preventive | 1 | 1 | 1 | 1 |
| 129856 | 12/07/2019 | 30/07/2019 | Preventive | 1 | 1 | 1 | 0 |
I created formulas to calculate the qty's of the Corrective and Preventive and also calculated the percentage of how many orders were created via the app. This is new in our company, that is why we are monitoring it.
The problem I am having is, we started using the app for Corrective services in April 2019 and for Preventive in June 2019.
I created this formula to calculate the App % per month and create a relationship between created and feedback date but I have to add a filter to show only the Preventive from 1st of June.
Prev FB M App% =
CALCULATE(DIVIDE([Prev FB M App-WO Tot], [Prev FB-WO Tot]), USERELATIONSHIP('Data - WO'[End of Month FB], Dates[End of Month]))
I am a new user and is not sure where to add the filter. Any help will be greatly appreciated.
Kind Regards,
Susan
