Aggr - Where to place conditional set analysis

[Anonymous]

I have an aggr calculation that is working for me:

avg(aggr(DPO,[Invoice ID]))

However, I want to add some additional criteria in here such as DataType= 'A' and FiscalPeriod='201502'.

I have experimented but I am not sure where to put the additional filtering statements.

Any help is appreciated.

Thank you,

- dave

[swuehl]

Ok, this explains what you were telling.

I read 'at the invoice header level' as that you are keeping an invoice header table in your model (which would solve this issue).