0 Replies Latest reply: Sep 15, 2010 4:49 AM by Dominic Ayling

# aggr - aggregated minimum/Maximum calculation regardless of selection in field

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