Hello, I have a bar graph that show different days when accounts fall into arrears e.g. Current, 30 Days, 60 days and so forth and at the moment i am using the following code to determine how many accounts fall into those specific catergories and it is date driven
sum( {$<[ARREAR GROUP]={'30 DPD'}>} [ERLM LOAN BOOK BAL] )
so if you click on the first of the month it brings up a certain total and if i click on the 2nd of the month it just adds on to the 1st total which is fine however i would like to know if it is possible that i can only get the value and count for the specified date without it taking into account the previous day?
