Skip to main content
Question

statistics calculator not working

  • February 9, 2020
  • 3 replies
  • 118 views
M

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.

 

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

milo89
Enthusiast
Forum|alt.badge.img+23
  • milo89Enthusiast
  • Enthusiast
  • 83 replies
  • 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.

M
  • muhammad_yasir
  • Author
  • 30 replies
  • 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.

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+23
  • milo89Enthusiast
  • Enthusiast
  • 83 replies
  • February 9, 2020

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

Community Stats

32,076
Posts
121,800
Replies
39,707
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.