Hi there,
I am calculating cumulative sum using one of the existing posts (https://knowledge.safe.com/questions/104692/running-total.html?childToView=104693#answer-104693 ). However, the problem is that I wanted to calculate the cumulative sum based on the regulatory year (1-4-Year to 31-3-Next Year). The Problem With the approach I have been using is it started cumulative sum from the start of the dataset. Is there any way I could calculate the cumulative sum based on the regulatory year.
Hi @muhammad_yasir, If the features have an attribute storing a regulatory year, you can set it to the Group By parameter in the StatisticsCalculator to calculate cumulative statistics for each year.
Hi @muhammad_yasir, If the features have an attribute storing a regulatory year, you can set it to the Group By parameter in the StatisticsCalculator to calculate cumulative statistics for each year.
I am calculating cumulative sum for regulatory year on monthly basis. For this purpose, I created column for Month-Regulatory year. Regulatory year starts from 1 April, and Statistic calculator do cumulative sum from April-RY to July-RY. However, it does not continue from August-RY to onwards. I have also used sorter on the date but didnt resolve the issue. I have attached the screen shot of statisticcalculator
Here is the snapshot of the date and cumulative sum.. As you noticed that when the month changes, values decreased, instead of increasing.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
