#CONTEXT Error

system · November 16, 2009, 11:08am

I have a report which has been sectioned but when I try add up a column I get a #CONTEXT error

HELP!!!

Sims786 (BOB member since 2006-04-04)

system · November 16, 2009, 11:32am

Try this one: https://bobj-board.org/t/121776

Antremons (BOB member since 2006-03-21)

MarkP · November 16, 2009, 11:47am

It may be the case that universe changes have been made since the report was build and that things that were previously compatible are now sat in different contexts in the universe. You may need to make a detail variable for a certain dimension to make the report work.

system · November 16, 2009, 12:16pm

I have used the following formula

InRange=If ([Period]>=[UserEntry_Start] And [Period]<=[UserEntry_End];[Hours];0

Where InRange and [Hours] are both measures

Still dont understand where the problem lies.

Thanks
Sam

Sims786 (BOB member since 2006-04-04)

system · November 17, 2009, 12:16pm

thanks fot your help

Sims786 (BOB member since 2006-04-04)

system · November 17, 2009, 12:32pm

Have you tried wrapping in a sum?

Sum(If([Period]>=[UserEntry_Start] And [Period]<=[UserEntry_End];[Hours];0))

Mak 1 (BOB member since 2005-01-06)

system · November 17, 2009, 12:39pm

It’s very hard to judge without seeing your universe , the formula is correct that’s for sure. My customer faced familiar error #UNAVAILABLE, that error was logged as product defect at that time and I’m still waiting for the solution

Antremons (BOB member since 2006-03-21)