Unable to create a summary field on a formula field 1

[TimBiesiek]

Hi All,

I am trying to create a summary field on a formula field within Crystal Reports, however, the formula I am trying to summarise does not appear in the list of available fields to summarize...

Some of the records for the formula are nulls... I thought this may be the reason?

Any help??

 

[paulmarr]

Tim,

The formula may be a Print Time formula (a formula that is calculated during the printing of the report as opposed to while the report is reading from the database.

In this situation - you may need to use a running total or even store values in variables and then display the variable where the total should be.

I hope this helps

Cheers
paulmarr

 

[dgillz]

Please post your formula.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[Madawc]

The presence of nulls wouldn't stop a formula being summarised - this does cause blank output, unless you use insull, but that's a separate problem. The usual reason is that the formula contains a summary.

What are you trying to do? Could it be done by a Runnning Total, which can count or add based on a formula?

It also helps to say which Crystal, though for the topics mentioned, all versions would be the same.

Madawc Williams (East Anglia, UK)

 

[TimBiesiek]

Hi guys,

Thanks for your quick responses!

Formula I would like to sum is:

if isnull({@RawFactor}) then
    1
else
    (sqr(sqr({@RawFactor})))*{@Attainment}

Using CR9...

I can't even create a running total on this field. It's not in that list either....

 

[lbass]

When posting formulas you should always post the contents of nested formulas as well. I'm guessing that one of the nested formulas contains a summary. You can use a variable to sum this, by creating two formulas:

//{@accum} to be placed in the where your formula is located:

whileprintingrecords;
numbervar x := x + {@yourformula};

//{@displ} to be placed in the report footer:

whileprintingrecords;
numbervar x;

If you are trying to summarize at a group level, then add a reset formula in the group header:

whileprintingrecords;
numbervar x := 0;

...and place the display formula in the group footer.

-LB

 

[dgillz]

Please post the formula for {@RawFactor} as well, plus any formulas it refers to. Also where is {@rawfactor} on the report canvas? Details section?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[TimBiesiek]

Heh heh.... I had started to copy and paste the other interelated formulas, but then thought 'Oh, they might not need them....' Duh!

Here's the other formulas:

RawFactor:

{@ActualRate}/{arc_Round.TargetRate}

Attainment:

({dlgV_057_ArchiveReadTypeR.Expr1}/{dlgV_058_ArchiveReadType.Expr1})*100

Actual Rate (Basic Syntax):

if {dlgV_056_HourDuration.HourDuration} = 0 then    
    formula = DistinctCount ({arc_FieldResult.ResultID}, {arc_Round.ArchivedSessionId})
else
    formula = DistinctCount ({arc_FieldResult.ResultID}, {arc_Round.ArchivedSessionId})/{dlgV_056_HourDuration.HourDuration}
end if

 

[TimBiesiek]

I want to display all theses formulas on the same area of canvas - a group header....

Then I want to summarise the points formula in the 2nd group footer... I will also want to summarise the points summary for the parent group.

 

[TimBiesiek]

Thanks LBass! Your solution worked! I have now got it to summarise the points formula by using your method! Thanks!

 

[lbass]

If you use the variable method, you can only display the results in a footer section, not a header section--although you could calculate the results in a subreport which uses variables, link the subreport to the main report on the group field, and place the subreport in the group header, if having the results in the group header is critical.

-LB