Page 1 of 1

Win Sum Filter

PostPosted: Thu Aug 06, 2009 6:16 am
by Joe
hi stan,

In Win sum filter, I entered the min/max range for a result, When filter the package the Jackpot ticket is missing, I re-checked the ranges again and again but i am having the same problem, please see the picture, the sum displayed is Win sum of tested result, the ranges in columns passed in 9 columns, so my setting was right, but it filtered out the winning ticket too, I really confused, can you guess what could be the problem here?,

thanks

PostPosted: Sun Aug 09, 2009 12:57 pm
by stan
you have 'logical condition - OR' selected. that's why the filter is failing i guess

PostPosted: Mon Aug 10, 2009 6:56 am
by Joe
to make " 9 to 11 columns must be passed " in entered ranges, we have to select "logical Condition OR" only, right?

PostPosted: Mon Aug 10, 2009 5:44 pm
by stan
i checked the source code and option 'at least x to y must pass' overrides logical and/or settings.

so i don't know why your jackpot ticket got filtered out
maybe you didn't filter the full package? or did you have any other options in the filter window selected? did you have correct winning numbers range selected? correct draw hidden?

PostPosted: Mon Aug 10, 2009 7:31 pm
by Joe
even I couldn't able to find whats wrong in my settings, me too checked it again and again, i couldn't see anything wrong in my settings, still having same problem... :wand: I am using build 1086

pls see the picture,

PostPosted: Mon Aug 10, 2009 7:40 pm
by stan
well, the picture shows that no draw is hidden in your database. so the values in the 'sum' column in the filter window apply to the latest draw in your database. the ticket in the package yields a different set of sum values

PostPosted: Tue Aug 11, 2009 3:26 am
by Joe
[quote=stan]the picture shows that no draw is hidden in your database.[/quote] stan, I skipped two latest draws in the database before apply the filter. see the picture.

PostPosted: Tue Aug 11, 2009 10:40 am
by Viking
Hi Joe,

I assume it is for draw date 17/2007 you filtered out the jackpot ticket with numbers 3-8-17-26-34-43?

Is the sum values for draw date 17/2007 414-781-1149-1571-1934-2304-2795-3232-3643-4068-4433? If it is, you have just 8 of them right when I compare them with the range for min and max sum in your first post above. You have chosen to use at least 9 to 11 columns must pass. Therefore this can be the cause of filtering out the jackpot ticket. Try to use 8 to 11 and see if it helps.

If the above sum values is not the right ones could you be so kind and post a picture of it (WN History/Summary Table/History Only).

Viking

PostPosted: Tue Aug 11, 2009 10:50 am
by Joe
[quote=Viking]Is the sum values for draw date 17/2007 414-781-1149-1571-1934-2304-2795-3232-3643-4068-4433? [/quote]
No, its 16/2007 win Sum, you can see the win sums for 17/2007 result at my 1st post in this topic, thanks

PostPosted: Tue Aug 11, 2009 4:08 pm
by MartinMan
Hello Joe,

I think that Viking is right. Your first post also shows that 3 of your sums are not in range. With your filter set to 9 to 11, you are only getting 8 sum ranges right. If you try it like Viking said with 8 to 11 must pass, then you should pass the filter. Or I am all messed up:)

Regards,
Martin

PostPosted: Tue Aug 11, 2009 4:15 pm
by Joe
MartinMan, There are 9 Ranges are passed, only -4 and -9 Columns are failed, pls check ranges in my 1st post,

PostPosted: Tue Aug 11, 2009 5:53 pm
by MartinMan
Hello Joe,

-2 shows a sum of 1114 a Min of 1125 a Max of 1167.
It looks like you are short of the Min by 11.

Regards,
Martin

PostPosted: Tue Aug 11, 2009 6:02 pm
by Joe
Oh how foolish I am..... Really sorry, sorry to waste all your time, thanks Martin

PostPosted: Wed Aug 12, 2009 3:52 pm
by MartinMan
Hello Joe,

I think maybe you just looked at it to many times :)
Sometimes it's hard to see things when you have looked to long.

Regards,
Martin

PostPosted: Thu Aug 13, 2009 6:23 pm
by Joe
[quote=MartinMan:1250085145]Sometimes it's hard to see things when you have looked to long.[/quote] you are right Martin,