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.

Pls help.

Many Thanks.

**RiaKapoor** *(BOB member since 2006-05-04)*