dflow Posted November 3, 2008 Share Posted November 3, 2008 hi how can one perform calculations in repeated regions: for example i want to create a report where: field#1 + field#2 = field#3( the SUM) AND SUM up AS TOTAL the whole column: total of all rows in column field#1 total of all rows in column field#2 total of all rows in column field#3 thx Link to comment https://forums.phpfreaks.com/topic/131192-how-to-perform-calculations-in-repeated-regions/ Share on other sites More sharing options...
PFMaBiSmAd Posted November 3, 2008 Share Posted November 3, 2008 WITH ROLLUP will probably do what you want - http://dev.mysql.com/doc/refman/5.0/en/group-by-modifiers.html Link to comment https://forums.phpfreaks.com/topic/131192-how-to-perform-calculations-in-repeated-regions/#findComment-681156 Share on other sites More sharing options...
dflow Posted November 3, 2008 Author Share Posted November 3, 2008 thank you will look into it Link to comment https://forums.phpfreaks.com/topic/131192-how-to-perform-calculations-in-repeated-regions/#findComment-681179 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.