Hi
The report has 2 group, level 1 is year and level 2 is department.
Those column are salesman_id, actual_sales, target_sales and the achieved rate
The format like this,
year department salesman_id actual_sales target_sales achieved rate
-------------------------------------------------------------------------------------
2009 A A1 1000 1200 83.3% (1000/1200)
2009 A A2 1100 1100 100% (1100/1100)
-------------------------------------------------------------------------------------
total 2100 2300
average 91.7% ((83.3%+100%)/2)
If I use average function, the value is 91.5%.
But actually, 91.3% (2100/2300) is real achieved rate.
Could I re-calculate this average value after report shows up?
Thanks <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=13230&image=1&table=forumtopics' class='bbc_emoticon' alt=':)' />