2 of 2 people found this helpful
Out of interest what result did you get when you say it didn't work?
Your formula seems ok, although the brackets clearly aren't correct and instead of '40% *' it should be '0.4 *'
For example, using your formula above, perhaps it should be:
(SUM([FixedAVGHourSession]) * 0.4) + (SUM([FixedAVGDayofWeekHourSession]) * 0.3) + (WINDOW_AVG(SUM([Sessions]), -7, -1) * 0.3)
I can't say for sure whether that will work as the table calculation may skew things, try it and see what happens. Please report back with any error messages you might get.
You could always slice these 3 separate calculations into 3 calculated fields and sum those 3 calculated fields as well.
My bad, its working very well!
Thank you for your attention!