Formula issue ..

[KYons]

Hello

I have the following problem
How can i get the sum of the Prd_Gr1=X in order to divide it trough the sum of Prd_Gr1=Y on a higher Group. On the report it has to look like following:

Prd_Gr1=X Sum= 152,77
Prd1--------------123,52
Prd2---------------29,25

Prd_Gr1=Y Sum= 291,29
Prd1--------------100,52
Prd2--------------10,00
Prd1--------------155,52
Prd2--------------25,25

Formula= 152,77/291,29 (The needed formula !!!)
How can i write this Formula ..??

 

[lbass]

Create two running totals where you select the amount field, sum, evaluate using a formula:

Prd_Grp1 = "X" //change to "Y" for 2nd running total

Reset never.

Then create a formula:

{#runningtotal1}/{#runningtotal2}

Place this in the report footer.

-LB