a simple summary

[msadesign]

This just has to be simple.

Look at the attachment: I need to add up all of the numbers in the 'Price' column. These numbers are the extended price and they are derived by multiplying the 'unit' by the 'qty'. Pretty simple.

I have a trailing grand summary. In the TGS, I have a calculation 'Grand Total', which is a summary field and equals the total of the extended price.

It is incorrect so I am doing something wrong, oh so wrong.

But what?

Michael

budget_opinion.pdf

[LaRetta]

It would help to see a picture of this layout in layout mode, Michael. :wink2:

[comment]

Hard to say without seeing the actual file. One thing that I did notice is that in your second row, Qty = 61 and Unit = 40.00, but the price is 560.00 - instead of the expected 2,440.00. Several other rows don't match either.

[RPCia]

I am having a similar problem.

In the pdf attached the last column total invoice has a total of 53,721.40, however if you add all the records up by hand it comes out to 53,721.44.

I added a couple of extra zeros to show the rounding.

This is set up as a header, body and trailing grand summary, displaying records from the invoice table.

I seem to recall something similar in version 6 but it was never more then a penny off.

test.pdf

[comment]

Doesn't seem to be similar - except that it's hard to say anything without seeing the actual file in your case, too.

[msadesign]

wow. I never noticed this- that the extended prices are wrong- I'll look at it and then post back. I think it has to do with the way I summarized the QTY column.

Yes, I should have shown the layout view. Thanks for the [gentle] reminder. I uploaded a shot of my field definitions. It has quite a few 'trial baloons' in it as I have been experimenting, so please forgive the messiness!

Michael

defs.pdf

layout.pdf

[msadesign]

OK, I see what is happening but I am not sure why.

[background: this plant list is derived from a drawing. I import text that represents the number of plants and the type of plant. This is why I have more than one row with the same type of plant].

In order to get the total number of a certain type of plant, I use a calculation and put it in a subsummary. The calculation is:

[summary] = Total of Qty

This gives me the total and it gives the correct result.

To get the cost of the plants, I have a claculation:

Unstored, = specs::unit price * qty

This does NOT give the correct result so I was doing something wrong here.

I changed this calculation and now using this:

Summary = Total of extended price

This is giving me the correct answers [it is in the trailing grand summary]. Thanks to everybody who pointed this out.

And finally, the initial reason for the post was the summarizing field at the bottom. Once the problem above was resolved, this calculation gives me the total I am looking for:

Summary = Total of extended price

So I now have the answer- if anyone can tell me how to have this subtotal showing without going to Preview Mode it would be great; but at leas the data is now accurate.

Now, I have many other issues [i am re-visiting a very involved solution that has been running the office for more than 15 years] but I'll start other threads.

Thanks to everyone. I mean it.

Michael