Monthly formula indicator fails to get correct scores when using PAFormulaUtil - Known Error

Monthly formula indicator fails to get correct scores when using PAFormulaUtil Description Monthly formula indicator fails to get correct scores when using PAFormulaUtil

Steps to Reproduce

On OOB Q:

1) Create an monthly indicator and collect 12 months of scores; 2) Create a fomula indicator with below formula: var dummy = {{ }}; pa.getScore($[[Indicator craeted in 1)]], score_start);

3) Navogate to user preference (cogwheel on top-left corner of home page), change time zone to be London or Amsterdam; 4) Navigate to AH of formula indicator, observe "No score" is e displayed (There maybe some scores are displayed but latest is missing); 5) Change formula to below: var dummy = {{ }}; pa.getScore($[[Indicator craeted in 1)]], score_end);

6) Navigate back to AH, still showing "No score".

You can navigate to monthly indicator for comparision purpose.

Workaround This issue occurs for user timezones that are ahead of GMT ( Ex: Asia/Kolkata (GMT+5:30) , London (GMT + 1)).

The following workaround would ignore user timezone and retrieves scores in corresponding PA Job timezone.

pa.getScore($[[Indicator]], new GlideDateTime(score_start.getYearLocalTime()+"-"+score_start.getMonthLocalTime()+"-" + score_start.getDayOfMonthLocalTime()+" 00:00:00"))