I would like an expression that depending on the day of the week moves the variable from vOneDayAgo to vTwoDayAgo. So the following expression on Tuesday would execute and give me the DayFilled.Days I'm looking for. On Wednesday I want to use the same expression only the if statement checks that it is vToday='Wed' and subtracts vTwoDayAgo instead of vOneDayAgo. So can I just add an additional expression like below just changing the vToday and vOneDayAgo? The following works for Tue:
(Sum({$<DaysFilled.Date = {'$(=vToday)'} >} if (WeekDay([vToday])='Tue',DaysFilled.Days))-
Sum({$<DaysFilled.Date = {'$(=vOneDayAgo)'} >} if (WeekDay([vToday])='Tue',DaysFilled.Days)))
I want to add to the same expression only changing vToday and vTwoDayAgo: Can I just add an
or after the above two statements?
(Sum({$<DaysFilled.Date = {'$(=vToday)'} >} if (WeekDay([vToday])='Wed',DaysFilled.Days))-
Sum({$<DaysFilled.Date = {'$(=vTwoDayAgo)'} >} if (WeekDay([vToday])='Wed',DaysFilled.Days)))
Is it this easy will it work with all four lines? I really appreciate any feedback.
