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.
