Crystal Formula Issue

[Former Member]

• 1)Body values of column A&B are formulae
• 2)I need a formula for calculating ‘Sum A’ & ‘Sum B’ which will add only body values of group3.
• 3)Once these Sum A & Sum B are available in formula, I can use these formulae to calculate
• Sum A/ Sum B to be placed in group3 of column C.

I have already tried following which are not working.

• I.Insert totals of column A & B, but they are not available in formula to be used.
• II.=sum (@bodyformula), this summing up everything in column A
• III.Weighted average in column C group3 header, giving some random values

Kindly help. Thanks in advance. Kind Regards.

Naoman D.

[Former Member]

..........

[abhilash_kumar · Accepted solution]

Why do you have the same field inserted as a group thrice?

-Abhilash

[Former Member · Accepted solution]

Yes we have different group of account ranges, top group is parent group with account ranges (say 1 to 10).

Group 2 will have sub range category say (1 to 2) & (3 to 4)......(9 to 10)

and group 3 is created for summarize data in order to avoid line items.

I can use formula (Sum A /Sum B) but only for any one of the group.

For rest their corresponding totals are not available to be used in formula. Thats why I need formula to sum up body values so that I can use them in column c calculations. Kindly suggest.