T
Tony Williams
I have 7 calculated controls on a report. The formula for each control is
(Nbr of reported clients in category/total nbr of reported clients) X total
of actual clients. The values for total reported clients is 39529 and the
total of actual clients is 44183. This is how the actual numbers look to 2
decimal places
cat1.......12920................Adjusted value(cat1/39529)X44183=14441.15
cat2........8060................Adjusted value(cat2/39529)X44183=9008.95
cat3........11335..............Adjusted value(cat3/39529)X44183=12669.54
cat4........2214................Adjusted value(cat4/39529)X44183=2474.66
cat5........124..................Adjusted value(cat5/39529)X44183=138.59
cat6........437..................Adjusted value(cat6/39529)X44183=488.45
cat7........4439................Adjusted value(cat7/39529)X44183=4961.63
Obviously I can't have part of a client so I have set the format to 0
decimal places and the report shows these figures:
cat1.......14441
cat2.......9009
cat3.......12670
cat4.......2475
cat5.......139
cat6........488
cat7......4962
Which you can see now add up to 44184. How can I cahnge my formula or format
of the calculated controls so that the report shows my correct totals?
Any help would be appreciated. I've been working on this for days using the
Round function, the Int function but can't get the desired result.
Many thanks
Tony
(Nbr of reported clients in category/total nbr of reported clients) X total
of actual clients. The values for total reported clients is 39529 and the
total of actual clients is 44183. This is how the actual numbers look to 2
decimal places
cat1.......12920................Adjusted value(cat1/39529)X44183=14441.15
cat2........8060................Adjusted value(cat2/39529)X44183=9008.95
cat3........11335..............Adjusted value(cat3/39529)X44183=12669.54
cat4........2214................Adjusted value(cat4/39529)X44183=2474.66
cat5........124..................Adjusted value(cat5/39529)X44183=138.59
cat6........437..................Adjusted value(cat6/39529)X44183=488.45
cat7........4439................Adjusted value(cat7/39529)X44183=4961.63
Obviously I can't have part of a client so I have set the format to 0
decimal places and the report shows these figures:
cat1.......14441
cat2.......9009
cat3.......12670
cat4.......2475
cat5.......139
cat6........488
cat7......4962
Which you can see now add up to 44184. How can I cahnge my formula or format
of the calculated controls so that the report shows my correct totals?
Any help would be appreciated. I've been working on this for days using the
Round function, the Int function but can't get the desired result.
Many thanks
Tony