formula is set to 'Group by period' but accumulation is done to all year

Hi,

In the Plan Element interval is set to period

I have the following formula that calculates grouped transactions

The goal is to count transaction with amount > 500k at end of each month and pay commission if count > 3

input:

Sum(Decode(Floor(transaction_amount/500000),0,0,1))

rate table

0:3 -->0

3:inf -->1

Output:

Rate Table result

Test Case

For July, I entered 3 transactions --> Input Achieved 3

For Aug, I entered 2 transactions --> Input Achieved 5

For Sep, I entered 1 transaction --> Input Achieved 6

I want every month to be grouped together. What is wrong here?