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)