I have already tried following which are not working.
Kindly help. Thanks in advance. Kind Regards.
Naoman D.
..........
Why do you have the same field inserted as a group thrice?
-Abhilash
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.
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 Ian,
Body formula is like
if date = {@parameter} then measure.
Thanks. I'll check ur proposed solution,
In footer also we can put. Could you please suggest code for the same. Thanks
You need a default condition it should then be available to sum
Try
if date = {@parameter} then measure else 0
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
All this assuming both formulas for Column A and B are not using print time functions.
-Abhilash
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