This Field Cannot be Summarized

[cLFlaVA]

Hi all.

I have a formula in my CR 10 report as follows:

Local NumberVar dblAssignedToRequests;
Local NumberVar dblAssignedToProjects;
Local NumberVar dblPlannedHours;

Local NumberVar dblStaffProfFTEs;
Local NumberVar dblPlannedFTEs;

dblAssignedToRequests := If IsNull( {Command.EST_REQ_EFFORT_HRS_1} ) Then 0 Else {Command.EST_REQ_EFFORT_HRS_1};
dblStaffProfFTEs := If IsNull( {Command.EST_SP_EFFORT_FTE_1} ) Then 0 Else {Command.EST_SP_EFFORT_FTE_1};
dblPlannedFTEs := If IsNull( {Command.PLANNED_FTE_1} ) Then 0 Else {Command.PLANNED_FTE_1};

dblAssignedToProjects := dblStaffProfFTEs * {@intNumBusDaysMonth1} * {@intNumHoursInADay};
dblPlannedHours := dblPlannedFTEs * {@intNumBusDaysMonth1} * {@intNumHoursInADay};

dblPlannedHours - ( dblAssignedToRequests + dblAssignedToProjects );

All I am trying to do is get the total for this field:

Sum( {@dblAvailHours1} )

But I am getting the error above. Is there anything I can do to avoid this? Why is this happening?

Thanks,

Cory

*cLFlaVA
----------------------------
[tt]your mom goes to college[/tt]
[URL unfurl="true"]http://www.coryarthus.com/[/url]

 

[cLFlaVA]

nevermind, i was lazy and didn't check the FAQs. sorry to waste your time.

*cLFlaVA
----------------------------
[tt]your mom goes to college[/tt]
[URL unfurl="true"]http://www.coryarthus.com/[/url]

 

[BobSuruncle]

If the other formulas that you are referencing in this one are second pass formulas, then you will not be able to use the Crystal Summaries.

A second pass formula is one the contains reference to a summary field, is explicitly marked WhilePrintingRecords or uses a shared variable.

In this case you'd need to use global variables to accumulate your values.


Bob Suruncle