>I have a VFP report with a group. The detail of the group includes a numeric value field. I want to do two things: add a field to the group summary band giving the total count of that numeric field in the detail band above, and I want to add a calculated field next to the numeric field in the band giving the percent that line (record) is of the summ of the band below. For example:
> Cars sold in:
>New York 5000 50%
>California 3000 30%
>Texas 1500 15%
>New Jersey 1500 15%
>_____________________
>Total: 10000 100%
>
>I can't figure out how to do this...neither with the report wizard nor using the properties. Does anyone perhaps have a report form they could show me that contains an example of how to do this? Or some other way of explaining it to me?
>
>Thanks!
>
>Jim
Jim,
I don't know a direct way of doing that with only report designer capabilities. OTOH you could sum the value "before" you go to reporting and save it in a variable. Then you'd just add a field with expression like :
ltrim(str(myFieldValue*100/mySum))+"%"
Cetin