No problem just letting you know I was trying to waste your time and energy by giving you extra work
.
Let's focus on the the second option.
FIrst let's validate the formula
if datediff("d",currentdate,{CDS_STATDAY.GamingDate})<180 then {CDS_STATDAY.TWin} else 0
Place it on a detail row and make sure it is doing what it should. FOr any record where the date is in the last 179 days (<180) it should put in the value from {CDS_STATDAY.GamingDate}). For anything else it should put in a 0.
IF that is happening correctly check your summary function field that should be placed on the group header1 or groupfooter1.
it should look something like
SUM(@Last180only, group1table.field)
Let me know where it stands from there.
IP Logged
