Why do you have the same field inserted as a group thrice?
-Abhilash
What is the formula used in @bodyformula
If it contains an aggregate function or a variable you can not use the Crystal sum function.
You then have to use either a variable or Running Total, however these can only be used in a group footer. It looks like you want to display in header, which will not be possible.
Ian
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
Add comment