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]

..........

[Former Member]

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

[Former Member]

Hi Ian,

Body formula is like

if date = {@parameter} then measure.

Thanks. I'll check ur proposed solution,

[Former Member]

In footer also we can put. Could you please suggest code for the same. Thanks

[Former Member]

You need a default condition it should then be available to sum

Try

if date = {@parameter} then measure else 0

Ian