Value of field to a variable as independent value.

building reports crystal reports
1

Hi, I need to implement a simple calculation as simple as C:=AvgBal, where Avg is the average of interest rate for that group and Bal is the sum of total balance for that group in Crystal. When i apply the above calculation in Group level ,crystal internally its calculating at detail level and showing the summation of the result at Group level, which is not the result i expected and also logically its wrong.(avgBal).
i tried to fetch the Avg & Bal values at group level to a constant variable and tried to multiply the two constants at group level which is also displaying wrong value.

I need the value of Avg as Balance to two different fields as independent values. so that i can apply the multiply there.
How can i achieve it? any suggestion plz.

regards,
Chaitanya B

krishnab :india: (BOB member since 2008-09-30)

2

Hi,

Create a formula and place it in the group footer. The formula should be like this:

Sum ({FieldName}, {GroupField})*Average ({Fieldname}, {GroupField})

Cheers!!!
Manish

cr_manish :india: (BOB member since 2009-07-30)

3

Hi Manish,
Thanks for the reply.
however as the fields are alreday grouped and when the calculation is implemented i get the same syntax as what you mentioned, which is not working.

Thanks,

krishnab :india: (BOB member since 2008-09-30)

4

Hi,

Can you send me the report with saved data?

Cheers!!!
Manish

cr_manish :india: (BOB member since 2009-07-30)