Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CRYSTAL REPORT XI, creating summary based on formula

Status
Not open for further replies.

dallasys

Programmer
Jun 26, 2011
1
US
i have a report(attached a copy).I want to create the percentage of summaries as below
"AMOUNT" "Amount For counties(1, 2, 3)" "County % Amount"
============================================================
8,900.89 6,600.00 6,600.00 / 8,900.89
4,500.57 3,500.57 3,500.57 /4,500.57

i used the below formula but its displaying .60(invalid) for all subgroup items and not even displaying correct value.
whilePrintingRecords;
Sum ({@newValue}, {Command.CODES}) / Sum ({Command.AMOUNT}, {Command.CODES})

can somebody help pls.
 
It appears that your formula is calculating for the outer group, not the individual county code. Please identify the fields you are grouping for each group and also show the content of your {@newvalue} formula--you should always show the content of formulas.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top