(InWeekToDate(D, Today(), 0)*-1 as CalendarCurrWTDFlag)
=
Sum({$<CalendarCurrWTDFlag={1}>} price )
So this basic extraction from my script and expression (in a table) shows you a basic idea of how we are trying to calculate total sales within the current week (month, year, etc).
My only problem is that not until long after having built this set of scripts did I realize that the day of the week begins on Monday instead of Sunday (therefore throwing off all of our calculations.
Is there an easier way to reinject the days of the week as Sunday-Saturday now that all of my work is done?
the InWeekToDate function has a 4th parameter - WeekStart - which may serve your need. (i've never used it, but by looking at the Help I think this is what you need...)
the InWeekToDate function has a 4th parameter - WeekStart - which may serve your need. (i've never used it, but by looking at the Help I think this is what you need...)
