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