Totals and percentage of totals in headers
Posted: Fri Apr 03, 2009 6:50 am
Hello,
I'am trying to do something like this (typical for obtain the results in a slaughterhouse) :
Big group Little part kgr neto result
Front part 1200 kgr 21% (12/57)
head 500 kgr 8.7% (5/57)
harm 600 kgr 10.5% (6/57)
neck 100 kgr 1.8% (1/57)
Middle part 2500 kgr 43.8%
breast 1500 kgr 26.3%
back 1000 kgr 17.5%
Hind part 2000 kgr 35.2%
Legs 1500 kgr 26.3%
Feet 500 kgr 8.9%
Total body = 5700 kgr 100%
I can not do it because the colunm of percentage is a division between Big group /total body, and little part / total body. The weight of each little part is the sum of many weights, so this is a report with 2 groupheaders, 1 footer, and 1 data band with many little weights from each animal (not showed here). For example the weight of heads, 500 kgrs is obtained from the sum of many figures.
My problem: I use the formula cSum(databand1, do.kgrneto) or cSum(od.kgrneto) it works if I place it in groupheaders but only in the first page. In the secon page, the report sums only the figures of the second page. But if I try to obtain the percentage of big group I can not. I've tried:
Sum(od.kgrneto)/cSum(od.kgneto) but it does not work.
Sum(databand1,od.kgrneto) / cSum(databand1,od.kgrneto)
and many other options ( built a new variable with the formula cSum(databand1,od.kgrneto) and meny others.
This report has many pages.
I can send images and mrt.
Thank you
I'am trying to do something like this (typical for obtain the results in a slaughterhouse) :
Big group Little part kgr neto result
Front part 1200 kgr 21% (12/57)
head 500 kgr 8.7% (5/57)
harm 600 kgr 10.5% (6/57)
neck 100 kgr 1.8% (1/57)
Middle part 2500 kgr 43.8%
breast 1500 kgr 26.3%
back 1000 kgr 17.5%
Hind part 2000 kgr 35.2%
Legs 1500 kgr 26.3%
Feet 500 kgr 8.9%
Total body = 5700 kgr 100%
I can not do it because the colunm of percentage is a division between Big group /total body, and little part / total body. The weight of each little part is the sum of many weights, so this is a report with 2 groupheaders, 1 footer, and 1 data band with many little weights from each animal (not showed here). For example the weight of heads, 500 kgrs is obtained from the sum of many figures.
My problem: I use the formula cSum(databand1, do.kgrneto) or cSum(od.kgrneto) it works if I place it in groupheaders but only in the first page. In the secon page, the report sums only the figures of the second page. But if I try to obtain the percentage of big group I can not. I've tried:
Sum(od.kgrneto)/cSum(od.kgneto) but it does not work.
Sum(databand1,od.kgrneto) / cSum(databand1,od.kgrneto)
and many other options ( built a new variable with the formula cSum(databand1,od.kgrneto) and meny others.
This report has many pages.
I can send images and mrt.
Thank you