Order from highest to lowest on a formula within a group

[sue1127]

I would like to order from highest to lowest variance within a group. The variance is determined by a formula which subtracts year-to-date balance(a running total) from budgeted amount(also a running total).

I thought I might be able to use TopN/Sort Group Expert, but that option is greyed out.

Does anyone have any suggestions as to how I might do this?

Thanks very much.

Sue

 

[paulosinuk]

Hi Sue,

I had similar issues with TOP/N and found it was because I was attempting to base TOP/N on a formula that used variables. If it's not variables then post the formula so that I can take a look.

Cheers

Paulos

 

[sue1127]

Paulos,

No variables are involved.

The formula is just:

{@chkrunbudaccount}-{@chkrunningytd}

@chkrunbudaccount is:
if isnull({#RunBudgetAccount}) then 0 else {#RunBudgetAccount}


@chkrunningytd is:
if isnull({#runningytd}) then 0 else {#runningytd}

Thanks,

Sue