This content has been marked as final. Show 2 replies
Make date is prompted in your report and create a new column in criteria with column formula as DAYOFYEAR("DATE"."CALENDAR_DATE").
This will give you sum of calendar days for year of selected date.
If you select 3/31/2012 then the result will be 91
if you select 3/31/2013 then the result will be 91
Hope this helps.