Nick Bowles
02/24/2021, 6:27 PMSELECT id, week(fromDateTime(datefield, 'yyyy-MM-dd')) as week, SUM(f1 * f2 * f3) AS "ftotal" ****THIS IS THE FIELD THAT RETURNS DIFFERENT RESULTS****
FROM mytable
WHERE year(fromDateTime(datefield, 'yyyy-MM-dd')) >= cast(year(now())-2 as long)
AND id in (123, 1234, 12345) AND f4 = 'blah' AND f5 in ('1-2', '3-4') AND f6 in ('foo', 'bar')
GROUP BY 1, 2
Jackie
02/24/2021, 6:32 PMNick Bowles
02/24/2021, 6:48 PMJackie
02/24/2021, 7:09 PMNick Bowles
02/24/2021, 7:09 PM