Calculations with aggregates

Classic Servoy
1

Please see attachment.
All columns are aggregates except for the right one.
The darkgrey row is a subsummary.
The white row is a other subsummary.
The left light grey column (SVJ) is a total of column 1-12 of year 2006
The right light grey column (SDJ) is a total of column 1-12 of year 2007
The light grey columns are aggregates.

The right column is a calculation based on aggregates:

return Math.round((sdj-svj)/svj*100)/100;
sdj en svj are aggregates

How come that some of the circled calculation shows nothing?
It should be showing:
-100,00%
+300,00%
-47,00%
-100,00%
-43,00%

Servoy Developer
Version R2 2.2.7-build 339
Java version 1.5.0_11-b03 (Windows 2003)

Java-Printing.gif
Java-Printing.gif1682×1190 46.7 KB

2

I really need your help on this one…guys.
I am having huge unexpected behaviour with aggregates.

The grey and underlined rows are subsummarys…see the attachments

2 columns with aggregates are summing stuff that isn’t there.

I am at loss here. I have redone the form over and over and I can get seem to solve the problem

Is this a bug? Is there a maximum amount of aggregates on a form??
I am pretty experienced with aggregates…but this one is illuding me

Many thankx in advance

Servoy Developer
Version R2 2.2.7-build 339
Java version 1.5.0_11-b03 (Windows 2003)

printoutput.gif
printoutput.gif1400×1050 44.2 KB

aggregations.gif
aggregations.gif703×543 7.61 KB

layout.gif
layout.gif1069×200 14.4 KB

3

Obviously it is hard to give you ‘the’ answer but could it be that you have null values in there? I have experienced some circumstances that did no good in that case. Do you do a check on that?

4

IT2Be:
Obviously it is hard to give you ‘the’ answer but could it be that you have null values in there? I have experienced some circumstances that did no good in that case. Do you do a check on that?

Yeah a lot of the fields have null values…Gonna put in some 0’s then
Thanx

5

Okay the removal of null values…solved the aggregate problem. Thankx Marcel.
Still the calculations of percentages are not working properly.

Does anyone know if there is a format…where the form doesn’t show 0 (zero’s) ?

In Filemaker there was a neat solution for that.

The reports is now filled with a lot of zero’s, making it a bit unreadable.