Totals

Ken Larsen

Hi

I have a report that is a invoicelist.
In the end of this page i want to have the total of all on each page.

When i use the Totals and then uses the Sum, it taks and put all the numbers after each other, like this: 320320320320, this is 320 four times, and it should be the total of this.
If i uses the function Count, it works, it show 4, and the same for Max, Min and Average, but not for Sum.

Sorry for my bad english, but i hop someone understand what i meen [img]style_emoticons/<#EMO_DIR#>/smile.gif" style="vertical-align:middle" emoid=":)" border="0" alt="smile.gif" /> Best regards Ken[/img]

gordk

make sure the display setting of the memo is correct and also that the
aggregate expression has the correct flag after the bandname.

Mick.pl

And yet make sure that a query gives you a numeric value instead of string/char for the column (memo) you want to sum.

Count ignores the type of ANY query."columnname".
Min and Max always work by comparing two values and taking only one of them (the same is for string values).

I'm not sure how Avg works (may someone tell us about it) :-)

But the result you've described (Sum(...) ) seems to be like concatenation of string values;

Mick