Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
RANGESUM(BELOW(SUM(DailyInterest),0,rowno())) + SUM(Interest)
can you try above one
@anat it produces the same outcome as before.