Skip to main content
Question

statistics calculator not working


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.

 

3 replies

milo89
Enthusiast
Forum|alt.badge.img+16
  • Enthusiast
  • February 9, 2020

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.


milo89 wrote:

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?


milo89
Enthusiast
Forum|alt.badge.img+16
  • Enthusiast
  • February 9, 2020
muhammad_yasir wrote:

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) "


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings