1

I have a Cognos Report created by a List. I used the Total function the report has to create a row of Totals, i.e. Total [TodayOrderCount] and Total [#ShipmentDaysOrder].

I then need to compute a division: Total [#ShipmentDaysOrder]/Total [TodayOrderCount]. For instance: 1,687/50=33.74

But instead the report shows 36.84 or any other number.

Does someone have experience with this?

Liliana
  • 11
  • 1
  • Hi Liliana and welcome. You have probably already checked, however I don't want to assume. What is the detail and summary aggregation property for the data item? Try setting them both to calculated Also, if that doesn't work, you could show an example of what the generated SQL is. It might be a package/ framework manager model issue – VAI Jason Feb 09 '21 at 21:40
  • Have you tried navigating to the query. Then with the tool, create a query calculation Expression: Total [#ShipmentDaysOrder]/Total [TodayOrderCount] Set the data item property for detail and summary aggregation to calculated – VAI Jason Feb 12 '21 at 21:14

0 Answers0