Solved: Re: Values Change in Append - Page 2

zimmermanaric · ‎02-19-2018

I am wondering if anyone has come across this before. We have 4 seperate databases that are all setup with the same table structure. I am pulling from the data for general ledger transactions from each of them as seperate queries for the past two years. When they are seperate, the summed value for all of the income statement accounts are rock solid. Each refresh shows the same answer. When I append all 4 of the queries together as a new table, each time I refresh I get a different result in the combined table for periods in the past that are closed.

Anyone have that issue before?

zimmermanaric · ‎06-26-2018

My apologies for the delay in response here. I was on vacation when you asked the question and the email was lost in my inbox until now. I did solve this purely by luck. It appears that if you have conflicting privacy levels (and sometimes even not) the append will give different results. I turned off the following option in my reports and things stablized:

File=> Options and Settings => Options=> Privacy

From there I chose the other radio button option "Ignore the Privacy Levels and potentially improve performance".

View solution in original post