SOLVED
Percentage conversion based on criteria
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Arnsen
7 - Meteor
‎03-30-2020
12:35 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I want to convert the [Result] data into percentage based on the criteria only if [Metric] = 'on time' or 'Labor %' or 'lag time'.
I have attached the sample excel file to it.
Solved! Go to Solution.
2 REPLIES 2
TomWelgemoed
12 - Quasar
‎03-30-2020
12:51 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Arnsen ,
Not sure I understood what you want to calculate fully, but attached is the direction I would go - a formula tool that looks for the words you mention in the metric field and then performs the appropriate calculation.
Let me know if you were after something else?
15 - Aurora
‎03-30-2020
12:59 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
