OK. Try this.

First make sure you use the summary function to get your group footer 1 totals. Do not use a formula. This will make this Summary an available item to select from in your data fields when writing a formula.

You will need to create running total for each of the day categories "total, future billed, current, 30 days, 60 days, 90 and over". You will have to tweak these since I do not know the actual date ranges for each.

Example 1 Running Total as "90_DaysAndOver":

Field to summarize:Amount

as a SUM

Evaulate as "Use a formula": datediff("d",{table.DueDate},currentdate})>89 and Sum (table.amount,invoice#)>0

Reset as Never

Example 1 Running Total as "60Days"

Field to summarize:Amount

as a SUM

Evaulate as "Use a formula": datediff("d",{table.DueDate},currentdate}) in 30 to 60 and Sum (table.amount,invoice#)>0

Reset as Never

Example 1 Running Total as "30Days"

Field to summarize:Amount

as a SUM

Evaulate as "Use a formula": datediff("d",{table.DueDate},currentdate}) in 1 to 30 and Sum (table.amount,invoice#)>0

Reset as Never

Example 1 Running Total as "Current"

Field to summarize:Amount

as a SUM

Evaulate as "Use a formula": datediff("d",{table.DueDate},currentdate})=0 or Sum (table.amount,invoice#)<0

Reset as Never

Example 1 Running Total as "FutureBilled"

Field to summarize:Amount

as a SUM

Evaulate as "Use a formula": datediff("d",{table.DueDate},currentdate})<0 and Sum (table.amount,invoice#)>0

Reset as Never