Hi im attempting to capture data and group it from wednesday until Monday. I am currently grouping my data by week number in Business Objects but this incorrectly puts the monday information in the next week. I want to capture and group data from wednesday until monday each week year to date.
I have been attempting a variable of =if [Day # of week] = "1" Then [Day # of week] -1
1 = a Monday and looking for it to show up in the previous week which would solve my problem.