COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: shital kumar on 04 Dec 2016 01:09:55 PM

Title: Add rate for each 24 hours
Post by: shital kumar on 04 Dec 2016 01:09:55 PM
Hi,

Report Studio Question


I wanted to make a sum of rate/cost for each 24 hours. Those 24 hours may or may not be in the same day. But not able to make a total of cost for 24 hours.

I have attached a screenshot for better understanding.


Thanks,
Shital
Title: Re: Add rate for each 24 hours
Post by: sdf on 04 Dec 2016 07:22:13 PM
what source are you using? DMR/relational/multidim?
is your "hours" data item as set or individual items?
Title: Re: Add rate for each 24 hours
Post by: shital kumar on 04 Dec 2016 11:52:42 PM
Thanks, for your reply sdf.

Its a relational model and the hours is a set. Actually i am splitting time and date from start_date field.



Thanks,
Shital