Sum All

I am trying to sum up a dimension field. I have a field called Order Number and than one called Days in System. This days in System field is a dimension. When I sum up the field I have no problems, it displays the correct number. However when I try to take the sum object and put it in a different report, the numbers no longer match.

here is the syntax:

=Sum(<Days in system>) Where (<30 days>="YES")

I also have a count field of the Oreer numbers. But that measure is working correctly.
Here is the syntax for the measure working:

=Count(<Order Number>) Where (<30 days>="YES")

Any ideas


khansen97 (BOB member since 2003-12-05)

So are and <30 days> both included in the block in the second report?


Anita Craig :us: (BOB member since 2002-06-17)

No, and they can’t be. Otherwise I get 2000 times the amount of rows I need. I just want to get that total number and put it in a cell on a seperate tab.


khansen97 (BOB member since 2003-12-05)