Display summary field in a graph? CR6 1

[Hottpepr]

I have a formula field that is the result of another formula field.
This field will not display the correct data when I Graph the report.
What am I missing?

 

[kenhamady]

Depends on the formulas. Can you list the formulas here? Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[Hottpepr]

Sure: here they are, The last one is not displaying correctly
· LOCATION: Left ({WOEQLIST.LOCATION},4)
· SQUAREFOOTAGE:
if {@Location}= "001A" then 184.6 else
if {@Location}= "002A" then 206.6
· LABORPERSQFOOTAGE: Sum ({WOE.REGHRS}, {@Location}) / {@SQUAREFOOTAGE}

 

[kenhamady]

What type of chart?
What version of CR? Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[Hottpepr]

CR version 6
Type: BAR
Data: Detail Formula
For each Group wo.wotype
Change of @location
value>> @squarefootage

does this help?

 

[kenhamady]

You are probably getting bars that represent your formula multiplied by the number of records in each group. This is because Crystal in V6 doesn't show you the implied "Sum" operation of the detail chart.

Here is a different approach:

1) Create a detail formula LABORPERSQFOOTDet:
{WOE.REGHRS} / {@SQUAREFOOTAGE}

2) add subtotal of this formula at the appropriate group (Insert Subtotal).
3) add a GROUP chart of this subtotal.

It should come out the same and a group chart will do what you want. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[Hottpepr]

That worked. Thank You