Hi All,
I think I have managed to find out why I am getting this issue with the
Match Winning Numbers Filter.
1. The Match Winning Numbers filter will work with lottery game formats where the main and bonus numbers are drawn from the same draw pool of numbers
2. It seems that lottery games such as Powerball where the Bonus number is drawn
from a SEPARATE pool of numbers that this issue will occur
3. What seems to happen is that the Bonus Draw numbers of any of the Past Draws which are part of your Selection Date Range is the same and appears in any of the Bonus Draw numbers in the lines in your filtered package then this cause a failure in your run of the Complex Filter using the Match Winning Numbers Filter.
Referring to my previous example where I have created a Complex Filter
using the Match Winning Numbers Filter.
From the image below of the Winning Numbers Table with the dates
6/1/22 - 10/2/22 highlighted you will see that Draw 20/1/2022 had a
Powerball of number "1".
Dates Analysed_2.JPG
When I insert a FULL Package I select all Main Numbers but also only choose to select number "1" from the secondary pool of Bonus Numbers (1 to 20) as inserting all Bonus Numbers will create a FULL Package size of 134,490,400 lines instead of a Package size of 6,724,520. I choose to do it this way as I do not include the Bonus Number in my analysis and have other methods of working out what Bonus Numbers to use for a Lottery entry.
This anomaly will also happen no matter what Bonus Number is selected when you insert a FULL Package. If for example I selected number "8" as my only Bonus Number when doing an insert then Draw 20/01/2022 will now allow whatever Target Draw I am analysing against to pass and Draw 06/01/2022 will cause a fail of the Target Draw that is being analysed as Draw 06/01/2022 has a Bonus Number of "8"
You do not have the required permissions to view the files attached to this post.