PA Indicator historical rebuild

Fabio Cresta · ‎03-25-2025

Hi All,

I'm new with PA indicators. I need to recalculate the historical value from a table that contains a start date and a cost.

As an example:

RECORD 1: start date: 1/1/2025 - cost $100

RECORD 2: start_date 1/2/2025 - cost $100

I configured the indicator and the job, In the job I set as relative start 2 month (I'm currently in march) to include January and February.

The problem I have is that, running the Job manually, in the indicator scoresheets I see $100 in January for both records, while for RECORD 1 I should have $0 on January and $100 on February..

Am I missing sonthing?

Thanks

Shivalika · ‎03-25-2025

Hello @Fabio Cresta

Could you please share screenshots ?

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket.

Regards,

Shivalika

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY

Fabio Cresta · ‎03-26-2025

Hi Shivalika, here are the screenshots.

In the sample data, we have 3 records starting with start date at different months. The Job is set to start 3 month before. I would expect to have a way (even by script) to have 0 on January for record whose start date is in February, same for the records starting on March. By having the same amount in months where the costs were 0 results in a wrong sum for the previous months