Collection CSV report weirdness

Day-to-Day Users
1

We are trying to figure out why the Collections. If you look at the queries. The first one is to load the data to the screen. The second query is for the CSV. Why is the second one so much longer than the first and repeats? I just wanted to get this on record.

collections_report_query2.txt (6.2 KB)
Report CSV has fewer rows than what is on screen. This is throwing off the calculations when summing the columns in the CSV.

The weirdness comes in the form of the query for each.

2

We figured it out. The reports don’t match unless export zero balances are selected when that is selected the columns sum to the same amount on screen.

1 Like