Variable Values Changing when using 'Sum'

[Snakeboy]

I hope someone can help - am at a total loss!!!

I have written a varible that calculates values, based on days between two events; it is essentually a sum of the number of cases which are within 5 days of each other. This is then broken down by another variable within the context of a table. The values appear accurate and good, but when i insert the same variable at the bottom of the table - to provide the higher level stats ie same value, without being proportioned out by the other condition, it changes the values of the table. Some of the cells show #IERR.

Any ideas???

 

[skrandel]

What does your formula look like? Make sure you tell us which objects are dimensions. Steve Krandel
BASE Consulting Group

http://www.baseconsulting.com

 

[Snakeboy]

=Count(<X>) Where (<Result 5 Dys>=&quot;Pass&quot

Result 5 Dys = = If <WrkDysBtwn><=5 Then &quot;Pass&quot; Else &quot;Fail&quot;

WrkDysBtwn is 'standard' triple nested formulae.

<X> is number of documents recieved - and the variable which splits it, is who sent it in...

Therefore the table should show the counts per sender, and at the bottom it should show the overall count - not the average.

Thanks.

 

[skrandel]

OK, you're trying to create buckets. These are almost always better created at the universe level using CASE statements.

I'm not sure you'll resolve this at the report level. Your bucketing variable uses an if. The problem is the subject of your if doesn't exist in the footer of the block.

I've gotten if's to work sometimes in footers, but not when bucketing is involved. If you send me you're report, I'll try to take a look at it over the weekend. Please ZIP it first.

skrandel@baseconsulting.com Steve Krandel
BASE Consulting Group

http://www.baseconsulting.com