Using an If Formula in a Formula Indicator - SYNTAX Assistance needed

[jstoessel]

I am working on an incident measure of "Percent Change of MTTR year over year" - with a breakdown by Business Service.

The basic formula is:

• ((MTTR This Fiscal Year-MTTR Last Fiscal Year)/MTTR Last Fiscal Year)*100

When both years have incidents closed - no problem. 

However, some Business Services are new This Fiscal Year, to Last Fiscal Year is a zero.

In a spreadsheet, I would use this to overcome the issue of the 0 value for Last Fiscal Year

When I attempt this using what I can find in Docs.ServiceNow.Com  I believe it is telling me this should be my format:

This is my error on SAVE:

When I replace the 

    else { 9 } with single digit - it saves and populates either the 1 or 9 , 

but instead of the 1, I need the equation to run.

I know I'm overcomplicating this - so I hope someone will just kickstart me into the right solution.  Thanks!

[jeffrubinoff · Accepted solution]

To the best of my knowledge, you cannot use logical operators like "if...else" in an indicator formula, only arithmetic operators like +,-,x,/, along with predefined time series aggregations and PAFormulaUtils methods.

[jeffrubinoff · Accepted solution]

To the best of my knowledge, you cannot use logical operators like "if...else" in an indicator formula, only arithmetic operators like +,-,x,/, along with predefined time series aggregations and PAFormulaUtils methods.

[AndersBGS · Accepted solution]

Hi @jstoessel ,

 you can’t use logic scripting in the formula indicator. instead you should state your logic in a scripted automated indicator for the data collection.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

 Anders