Hi folks, This is a Relational Framework Request for help! Cognos 11 Analytics
I have come up with a Data Item that does the below but the below is returning (0) unfortunately.
If [report_date] >= _add_days (?Prompt Date?,-365)) then
(_days_between][report_date], [closed_date])
else
(0)
So all I need to do to return the days between if [closed_date] falls within the last 365 days but
in a Data Item within the same Query that may have the same for going back Two Years, etc..
Pls help if you can.
Thanks
The code looks fine to me.
Try filtering the data to only have rows that have a closed date in the last year.
Then build up the calculation one step at a time to make sure each clause is working correctly.
Also, obviously, remember to check the aggregation/roll-up types on the finished data item.