View Single Post
Old 11-30-2018, 12:09 PM  
sarettah
see you later, I'm gone
 
Industry Role:
Join Date: Oct 2002
Posts: 14,164
Lat night, at midnight, there was still a touch over $20.00 to go.

This morning when I got up at 6:40am (an ungodly hour I must say) we were at $99,999.99. I kid you not. You can't make this shit up.

I have been using a total screen from the stats and doing a date range of January 1, 2014 - Now for all the totals. When I went to double check the total, because it was just one penny, I took the last total from the 28th and added the 29th and a little from this morning to it and that way it came out to exactly $100,000.

I was like WTF? I checked both ways again. One way said 99,999.99 the other said 100,000.

Turns out that the total column in CB's stats does not contain the sum of the column but instead contains 20% of the total sales. When they do the rounding they lose the penny I was seeing.

Since I have been using the entire date range screen for the contest I decided to stick with that. So, as of 6:40 am this morning we are at $99,999.99

Here is a screen showing the mistake:



Here are the stats as they were when I woke up:



And here is the calculation showing the total:



.
__________________
All cookies cleared!
sarettah is online now   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote