IF Statement or similar

robertmueller · ‎12-20-2018

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?

Alikutty A · ‎12-20-2018

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 }

View solution in original post

Jim Coyne · ‎12-20-2018

It might be helpful for others to know what it is you did to fix the issue. Please share if you don't mind. Thanks

robertmueller · ‎12-20-2018

Yes of course, I had to change it to a monthly figure which I still need to sort out, but effectively

if ([[Indicator name/ By month SUM +]] > 0) {43920/[[indicator name/ By month SUM +]]} else { 43920 }

Please note that 43920 is the minutes in the month based on 30.5 days in a month. I still need to get it to calculate based on the actual days in the month, ie 1440 x days that month.

Alikutty A · ‎12-20-2018

It would have been fair enough to mark the correct answer for the original question posted!

robertmueller · ‎12-20-2018

Alright calm down I didnt know you could only select one as the correct answer, nor did I know people are so competitive with getting marked as correct on a open unpaid community board.

Alikutty A · ‎12-20-2018

Thank You !! This is just a token for unpaid support. Much appreciated!