Selection Issue

[BrunPierre]

Greetings to all,

So I have this QVD where records seize to update incrementally, the last record is dated 25/04/2022. However, I enable to generate new dates to calculate the interest accrued with the expression; RANGESUM(BELOW(SUM(DailyInterest),0,NOOFROWS())) + SUM(Interest). 

My challenge is whenever  I select any subsequent date, the amount defaults to 5,263.25, that's the initial amount as of 25/04/2022.

Table without any date selection

Table with 27/04/2022 selection

Apparently, in the above scenario, the amount should read 5,409.45 and not 5,263.25.

Help me out here, please!

[anat]

RANGESUM(BELOW(SUM(DailyInterest),0,rowno())) + SUM(Interest)

can you try above one

[BrunPierre]

@anat it produces the same outcome as before.