The issue I'm having is comparing 30 60 90 etc DEBTOR days overdue over time. With just the unadjusted data I get a nonsense figure due to the credits not allocated. I want to exclude the credit value by customer. For example 86417 credit compared too 130429 debit with the credits excluded

The two measures were as follows

AR Over 120 Days O/S

sum({<CanonType = {TransDate} ,GLTransType = {ARDetail,ARAllocate}

>} if( ARDueDate+121 <AsOfWeek ,

ARValue))

Over 120 Alt (alternative measure where negative values were excluded)

I don't fully understand your use case - I'll make an educated guess that you're trying to exclude certain accounts from contributing towards your totals if the net position per month is = zero. There must be a bit more to it though as if the net position per month per account is zero - it won't impact the totals, so why take it out? Anyway, disregarding my requirement knowledge gap - to support this type of logic you'll need to make use of the Aggr statement. It allows you to compute figures at a grain of your choosing, so you can do your sum(Value)>0 check per account per month and sum up the remainder. Something like the following should do the trick: