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

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

    Dominic Ayling

      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