BusinessObjects Board

DMB0007 error using where /Computational error using If.Then

building reports desktopintelligence
#1

Hi Experts,

My report is bringing data for 12 months. I need to show data for 12 months first and then delta for last 2 months. I hv created variables for maxmonth and maxmonth -1 and trying to create variables for max month charge and maxmonth-1 charge.

When I use formula as max month charge:
= Where ( = ) I get DMB0007 error. I tried changing the Numeric variable maxmonth into character using FormatNumber then using variable as
= Where ( = “”) then I dont get error but this variable doesn’t bring any data.

I also tried using the formula in the variable as ;

=If(In Block = Or In Block = - 1) Then Else 0

I am getting COMPUTATION error. :hb:

Pls help.

Many Thanks.

RiaKapoor :india: (BOB member since 2006-05-04)

#2

This is because Where operator in Desk-I accepts only constants to be compared. Check here

In this case, you’ve to have all the dimensions present in the formula inside the block too… If you don’t want the dimensions to appear in the block, just hide them.

Jansi :india: (BOB member since 2008-05-12)

#3

Hi Jansi,

 Thanks. I am facing the same error message. it got resolved with your suggestion.

thanks.

kucherlapati :india: (BOB member since 2008-06-18)