last 12 months average outsanding ?

[#1]

Hi All,

I am Getting Out standing Amount as Expression, like (Out Standing Amount = Original Amount - Adustable Amount)

I need to get Last 12 Months Avg Out Standing Amount on Custcode ?????..

=num(Avg(aggr(Sum({<[Invoice Date]={'>=$(=MonthStart(Max([Invoice Date]), -11))<=$(=Date(Max([Invoice Date])))'}>}(sum(Original Amount)-Sum(Adjustable Amount))),CUST_CODE1)),'#,##0.000')

I am getting Null Value Last 12 Months Avg Balance Amount column....

Can any one help me on this ..

[Gysbert_Wassenaar]

You're nesting sums without an aggr: Sum({<...stuff... >}( sum(Original Amount)-Sum(Adjustable Amount) ) )