Troubleshoots the Performance Analytics Admin Console - "Formula indicator with invalid formula"

Bodige
Tera Contributor

Hello,

 

Diagnostic was "Formula indicator with invalid formula"

 

as we click on the problem record it was refereeing to the below formula 

 

Actual Formula:

 

var lastDayInPeriod = score_start.getYear() + '-' + score_start.getMonth() + '-01';
lastDayInPeriod.addMonthsUTC(1);
lastDayInPeriod.addDaysUTC(-1);
pa.getScore($[[Number of open Catalog Tasks]], lastDayInPeriod);

 

even we have troubleshooted the formula by providing the indicator which has no breakdowns even we were not able to fix the formula. 

 

and also, we have tried with the associated contributing indicator -

in which it has 8 breakdowns even after running the diagnostics for each of it we have not found any diagnostics results.

 

How can I determine, which indicator can fix the error.

 

Can someone help me on this query please.

 

Thanks,

Apoorva.

 

 

For this issue we have found the solution as:

 

The answer from the HI team was to use "getYearUTC" and "getMonthUTC" instead of "getYear()" and "getMonth()". I

have Updated formula as getYearUTC() function instead of getYear() Same for getMonthUTC() function instead of getMonth(). Fixed the error by running the diagnostic after updating values.

Having too many elements to display could cause an issue too.

 

Updated Formula:

 

var lastDayInPeriod = score_start.getYearUTC() + '-' + score_start.getMonthUTC() + '-01';
lastDayInPeriod.addMonthsUTC(1);
lastDayInPeriod.addDaysUTC(-1);
pa.getScore($[[Number of open Catalog Tasks]], lastDayInPeriod);

 

Thank you.

0 REPLIES 0