http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 02 May 2026 00:18:38 +0000 Fri, 04 Sep 2015 05:46:37 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=22712 http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ http://forum.codejock.com/forum_posts.asp?TID=22712&PID=73861&title=bug-with-sumsub-and-moving-columns#73861 Author: skiman
Subject: 22712
Posted: 04 September 2015 at 5:46am

Hi,

Using SUMSUB gives a lot of problems when moving columns. I have the following.


There is a grouptotal on the column Bedrag (amount). This is correct.

Now I move the column Bedrag to the second Column.


As you can see, the subtotal now totals the originally second column, which is the Date column. The subtotal is the sum of the days.

The cause of this problem is the way subsum is defined. It would be better to have a formula property for a column. Also the subsum should use the ITEMINDEX to define which items must be totalled.

I can dynamically change the groupformula, but with the current system i can't define in which column I want to put a subtotal, and I can't define that the subtotal in column 2 is in fact the data from item 4.

Anyone who uses this component and found a solution for this? I'm afraid there isn't any with the current behaviour and implamentation of the groupformula.

See also my previous post about the use of formula: Topic: row:groupformula <-> column:groupformula.]]> Fri, 04 Sep 2015 05:46:37 +0000 http://forum.codejock.com/forum_posts.asp?TID=22712&PID=73861&title=bug-with-sumsub-and-moving-columns#73861