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]

Hi Naoman,

1. Sum({@Column A formula}, {Group 3 field})

This will return sum of column A only for Group 3. Place this formula on the Group Footer 3.

2. Use a similar formula for Column B.

3. To divide these two, use:

If Sum({@Column B formula}, {Group 3 field}) = 0 then 0

else

Sum({@Column A formula}, {Group 3 field}) / Sum({@Column B formula}, {Group 3 field})

-Abhilash

[abhilash_kumar]

All this assuming both formulas for Column A and B are not using print time functions.

-Abhilash

[Former Member]

Hi Abhilash,

Thanks for your reply. No there is no print time function in column A & B.

I tried your solution, it gave incorrect results.

What I mean is when I put Group 3 field (Account Number), it is giving sum of all the values.

However all the groups (Group 1 & Group 2) using same field, that might be the reason.

And that might be the reason why totals are not available in formula.

Any further suggestions.

Thanks