Skip to Content
0
Former Member
Jul 01, 2009 at 02:49 PM

Formula Problems

29 Views

I'm using BOXI r2 sp4 and I've created a crosstab report that has three different date prompts to compare base and productivity measures.

Initially, I started with 3 blocks, but had to change it to 1 block because of alignment problems.

Can someone correct the following formula and explain what I am doing wrong?

Base Month should return the 3 following measures:

Cost of Service

Billing Units

Rate

and if my dimension is NOT equal to the Base Month then it return the first 3 measures plus 3 additional measures

Cost of Service

Billing Units

Rate

Productivity

Volume

Total Impact

=If([Base BYM Description]=[Base Month];[Cost of Service] And[Billing Units] And[Rate];If([Base BYM Description]<>[Base Month];[Cost of Service] And[Billing Units] And[Rate] And[Productivity] And[Volume] And[Total Impact]))

but the bloody formula returns the following error message:

The expression/sub-expression at position 40 an invalid data type. Specify a valid data type. (Error: WIS 10037)

I'm not sure if these codes will help clarify the context, but I'll add them anyways.

The Base BYM Description has the following code:

=If([Billing Year Month]=[Base Month];[Billing Year Month]; If([Billing Year Month]<>[Base Month];[Billing Year Month];[Billing Year Month]))

The Base Month has the following code:

=(UserResponse("Enter Billing Year Month for Base Rate:"))

Any help would be greatly appreciated!

Wannetta