Skip to main content
  • EN

Hi there,

I am trying to calculate cumulative sum of an attribute for each regulatory year. I am using a statistic calculator for calculating cumulative sum. However, I noticed that statistic calculator does not give the right result. It calculates the total sum of an attribute over the regulatory year and shows it on every row. For example, the value of the cumulative sum of an attribute on the first day of regulatory year is same as the value of the cumulative sum of an attribute on the last day of regulatory year. I am using FME 2019.1. Any help to fix the issue would be really appreciated.

 

Hi @muhammad_yasir

I believe the problem you're having is the same as in these two posts:

https://knowledge.safe.com/questions/102581/statisticscalculator-suddenly-not-yielding-the-sam.html

https://knowledge.safe.com/questions/102959/incorrect-results-from-statisticscalculators-cumul.html

According to the comments in the first post, the issue has been fixed and available in FME 2019.2.1 which was released in December.

Hi @muhammad_yasir

I believe the problem you're having is the same as in these two posts:

https://knowledge.safe.com/questions/102581/statisticscalculator-suddenly-not-yielding-the-sam.html

https://knowledge.safe.com/questions/102959/incorrect-results-from-statisticscalculators-cumul.html

According to the comments in the first post, the issue has been fixed and available in FME 2019.2.1 which was released in December.

Thanks for replying. Our IT department has not planned to update FME to the next version, for next 4 months. Is there any other way of calculating cumulative sum based on regulatory year?

Thanks for replying. Our IT department has not planned to update FME to the next version, for next 4 months. Is there any other way of calculating cumulative sum based on regulatory year?

I would suggest trying the workaround provided by @ebygomm in the second link above.

"If you add a python caller prior to the statistics calculator, it seems to sort it out (you don't appear to need any code other than the default) "

Reply


Community Stats

30,176
Posts
114,541
Replies
37,835
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.