Hello I have a situation that i cant figure out.

Imagine this, i have a database where i have two currencies say USD and Pounds

(i should also mention there is a currency group)

and i have this field where i wanna get this average.

so one field is as follows

Sum.fund  = (Sum of fund, resets on a group)

totalfieldans  (name of formula field)   =    SUM({personal.fund})

and

{#Sum.fund}/{@totalfieldans}*100

So  basically what i want to do is, the sum of fund / totalfieldans* 100

this works 99% the only issue is, getting totalfieldans is supposed to group by currency

so lets say the SUM of USD is 50 and the SUM of Pounds is 60

for fields under the USD group i expect  the formula to be

fund / 50* 100

NOT

fund / 110* 100

Thanks for your help