Hi All
I'm calculating a rank for a minichart in a straight table and have dynamic min and max. For the min and max functions I'm using the aggr function with a min. Here's the function:
[CODE] =min(total aggr(Sum ({$<[4AC - Level 4 Account Code] = {'PAY','NONPAY','INCOME'},[4AN - Level 4 Account Name] = {'Pay Costs','Non Pay Costs','Income'}>} Actuals*CalCurYTDFlag)-sum({$<[4AC - Level 4 Account Code] = {'PAY','NONPAY','INCOME'},[4AN - Level 4 Account Name] = {'Pay Costs','Non Pay Costs','Income'}>} [Budget 1]*CalCurYTDFlag),ExpenseGrp))[/CODE]
The problem I'm having is that when a selection is made in the field [4AC - Level 4 Account Code] this reduces the available values in ExpenseGrp and the aggregation only then aggregates on the remaining available values - I want it to aggregate by all values available in ExpenseGrp with the selection as per the set analysis, i.e. [4AC - Level 4 Account Code] = {'PAY','NONPAY','INCOME'}. Like set analysis for the aggr section (but that doesn't work).
Many thanks
Dominic