Add rate for each 24 hours

[shital kumar]

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

[sdf]

what source are you using? DMR/relational/multidim?
is your "hours" data item as set or individual items?

[shital kumar]

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