- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-20-2018 05:25 AM
Hi All,
Does anyone know the formula that I would need here.
I have a calculation (formula indicator) that is 1440/(count of incident) so for example if there was 5 incidents that day it would be 1440/5. Simple enough, however I need to be able to state that if there were no incidents that day the answer should be 1440 not 0 like it currently gives. Can anyone help?
Solved! Go to Solution.
- Labels:
-
Performance Analytics
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-20-2018 05:35 AM
It would be something like this, Replace with your actual indicator name and try it
if ([[Count Of Incidents Indicator]] > 0) { [[1400]]/[[Count Of Incidents Indicator]]} else { 1440 }
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-20-2018 06:54 AM
Indeed, it can get a quite competitive, as there are some perks to earning points. 🙂
Although I appreciate the points, I'm more interesting in closing out the questions so others can see the solution to the issue. And sometimes the proposed solutions are not necessarily the best way to go about things, so I like to point that out as well.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-20-2018 06:45 AM
Perfect, thanks for sharing.
