Skip to Content
0
Nov 25, 2018 at 12:28 PM

Variable to capture data from Wednesday until Monday

58 Views

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.

Thanks all.