IF Statement or similar

[robertmueller]

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?

[robertmueller]

if ([[Count Of Incidents Indicator]] > 0) { [[1400]]/[[Count Of Incidents Indicator]]} else { 1440 }

Seems to work and provide scores in the score card, thank you. However my next issue is that the widget/graph does not seem to be adding up the scores over the month.

[robertmueller]

I think I have sorted it thank you everyone

[Alikutty A]

Hello Robert,

Can you mark my response as correct answer, if you query on formula was resolved? Thanks!

[robertmueller]

Already done

[Alikutty A]

Not reflecting as correct answer 😞

You may need to click on Mark as Correct Answer as highlighted