Hello Cognos community,
I have a data item that calculates the number of orders that a supplier didnt deliver in time for each month that looks like this:
case
when
([Received date] <> [Requested date] and [Ordered quantity] <> [Received quantity]) then 1
else 0
end
What I want to do is to create a running total for each month. So if I choose Mar I want to see the numbers Jan + Feb + Mar.
So I created a new data item using the data item above:
running-total([Wrong time, wrong quantity] at [Supplier],[Month] for [Supplier])
This is what it displays:
Jan Feb Mar
Supplier Wrong time, wrong quantity 7 3 5
Running-Total 0 0 1
Desired result for running total would be:
Jan Feb Mar
Supplier Wrong time, wrong quantity 7 3 5
Running-Total 7 10 15
This is a relational data source and thank you for all the tips on running-totals.
Best regards,
Oscar
*Solved it*
It was an aggregation issue, so changed detailed aggregation to default and summary aggregation to total.