Hi All,

I have an banking report for vault drawer analysis report. In this I have two grouping first one is currency and second one is drawer. That we have more than one darwer for tha same currency.

I have the following formula for doing summarize for the drawer group:

Formula-1(denominationtotal)

{RPT_VAULT_DRAW_CRNCY_DENOM_SP.DENOM_AMT}*{RPT_VAULT_DRAW_CRNCY_DENOM_SP.DENOM_COUNT};

Formula-2(difference)

shared numberVar result;
result:=sum({@denominationtotal},{RPT_VAULT_DRAW_CRNCY_DENOM_SP.DRAWER_NO})-{RPT_VAULT_DRAW_CRNCY_DENOM_SP.DRAWER_CRNCY_BAL};
result;

the above calculated result is for total for particular drawer. So i want to sumup the "result" variable in currency level. That is sumup for all the drawer which are all having the same currency.

Please give me some suggestion