on 11-25-2018 12:28 PM
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.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.