Hi,

I currently have a Master - Child relationship as follows:

Payment Schedule
     Payment
            custom field of Due Date
            custom field of Balance Amount

I want to be able to have a custom Roll Up Summary field  on the Payment Schedule that only includes a Payment Balance Amount if the Payment Due Date is either today or before today, <= TODAY()

I've looked at using the Criteria filters, however this gives me a formating error when using TODAY

I've looked at using a seperate Payment Custom Formula Field that is Payment Due Date - TODAY(), but this custom filed, once set does not appear in the list of criteria that I am able to set on the RUS.

After some research, I know that you cannot seem to be able to use derived values within RUS' 

So what is the common work around? We want to be able to do some APEX coding on this new Balance To Date field as well as show it on the Payment Schedule object in real time. So I don't think Workflows is also the answer as we don't want to have to be saving all Payments on a daily basis to update if that Payment is overdue or not.

Thanks

Martin Vernon
Lead Developer - Select Property Group