Maybe I am just Friday tired, but I am struggling a bit here. Trying to create a report that would give me the number of cases opened each week (across the top of the report), by year (down the left side).
I used the following formula to create a "Opened Week" formula field:
MOD(FLOOR( (DATEVALUE(CreatedDate) - DATEVALUE("2006-01-01" ))/7),52)+1 per SF article 000249334.
Used that field at the top of the matrix report. But I have weeks 1 and 2 coming in as 0 which is not even remotely possible. I decided to check other numbers, and they don't seem right either.
Does the formula have to have a line for every year? Or does it just need that one line?
Thanks in advance!
Kim
답변 3개
Hi Kim, I would change the formula to the below to get the week number and see if this makes any difference
MOD(FLOOR((DATEVALUE(CreatedDate) - DATE(YEAR(DATEVALUE(CreatedDate)),01,01))/7),52)+1
