Calculating a Percentage Based on Filtered Item Type Counts

I am attempting to calculate a percentage based on a total task count sorted by total item types. The logic is something like this:  (ItemType1+ItemType2+ItemType3)/(ItemType4)=%. 

Basically, I am trying to calculate an error rate. Tasks in item types 1-3 are production units, whereas tasks in item type 4 are rework units. I would like to return this percentage for each employee. Here is my current set up. What am I doing wrong?

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos
3 comments

Hey Ali Moses, I've asked our Wrike Analyze Support specialists to look into this for you 👍

Lisa Community Team at Wrike Wrike Product Manager Become a Wrike expert with Wrike Discover

Lisa Wrike Team member Become a Wrike expert with Wrike Discover

1
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Lisa Thanks so much!

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Was there a resolution on this?

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Folllowing List for Post: Calculating a Percentage Based on Filtered Item Type Counts
[this list is visible for admins and agents only]

Top
Didn’t find what you were looking for? Write new post