Hello ,
I am trying to calculate the distinct number of records as of the end of each period (Parameter) after the beginning of the calendar year.
I didn't have that problem with the Rolling Amount ($), but can't get to work the rolling count. Any ideas will be appreciated.
7 Antworten
Hello,
I was able to resolve this calculation myself
The solution is simple ( took me some time) - for each record I have to pull only the first evaluation date and based on that I get the count of the rolling sum
You can see the final Version attached.
Thank you!
