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.
"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.