Summarzie Won't Total same as Report

[Leah]

I have a table with multiple Records for a Person with a 19.9 decimal value. When I create a Report that does detail with a total and another that doesn't show the detail just the total for each person - the numbers match. I then Summarize the table by name and it rounds differently. I need to summarize so I can create a table with just one record per person in order to do a Word Merge. I have tried even doing the summarize, but only appending an empty table with name only and then posting from the detail table by Adding the values - same result. I have attached an picture of the problem - DB is too big to upload whole thing

[Al Buchholz]

Re: Summarzie Won't Total same as Report

Leah

We don't need the whole database, but a small table with a few records and a summarize operation that shows the problem.....

[Leah]

Re: Summarzie Won't Total same as Report

Al- sorry it has taken me so long to get this to you - took awhile to strip this down. Under the Scripts -do RUN, then pick 1st report for the Detail, 2nd one for Summary - All these are Calculated via the report and come out correct - then look at table Owners_unit_netintsum - field net_unit_int - this number should match what is on the report for Net Unit Int - and as you can see it doesn't. The summarize that creates this field is operation Owners_Netint_sumz (3rd from last operation on R_Unit_Assign) I know it goes thru a whole bunch of operations to get to this point, but there is reasons for it
Thanks

[Al Buchholz]

Re: Summarzie Won't Total same as Report

Leah

I've not had good success running a string of operations from an action script. Each operation tends to run in their own thread and therefore can get out of synch.

I've usually converted them to functions and run the functions to preserve the single threading that is needed.

You may get the desired results by right clicking the action script in design mode and view xbasic - all actions tab - copy to clipboard.

Then paste into a xbasic script and run that script...

You'll probably get the correct calculations. Let us know..

[Leah]

Re: Summarzie Won't Total same as Report

Al - I have tried to run the summarize option stand alone and get the same result - even created a table with just records for 3 of the people I needed to summarize and still didn't work - so I don't think its the operation

[Tom Cone Jr]

Re: Summarzie Won't Total same as Report

Leah, break this down into smaller steps for us to follow along.

If I run the summarize operation named "Owners_netInt_sumz" it populates a table named "Unit_div_ord_summ". The totals there do not have a rounding error.

What am I doing differently than you?

[Leah]

Re: Summarzie Won't Total same as Report

thanks Tom - if you run the first two reports from the report list, you can see what the totals should be - and when you summarize its different - they all have to be the same - no matter what I do I can't get them to match - thanks for the help.

[Tom Cone Jr]

Re: Summarzie Won't Total same as Report

Leah, please be more specific. The first two reports listed on the reports tab of the control panel are Assign_Lease_ORRIF and Assign_LeaseU. Are these the reports that you want us to run?

When I run the summarize operation named "Owners_netInt_sumz" it populates a table named "Unit_div_ord_summ". The totals there do not have a rounding error. I've verified that by manually adding all the net_unit_int for Wilma and Clifford Jewett, and the manual total matches the total generated by the summarize operation, when run separately.

Wilma and Clifford Jewett don't appear in either of the "first two listed reports".

May I suggest that you retrace my steps, using the sample data set you gave us, instead of working with your original ?

Alternatively, may I suggest you retrace your own steps, using only the sample data set you gave us, instead of working with your original?

-- tom