Invalid to compare values with different dataTypes

[jd]

Hi,

I am working with cube based report. In my cube One_ID is the dimension(values are1,2,3,4,5 ..to 20)

I have to get a calculation based One_ID. So I am doing like this
total(if( [REGION11].[ONE_ID].[ONE_ID].[ONE_ID1].[ONE_ID - Long Name]=16)  then([Total Cost]) else (0))

I am getting below error:
Invalid to compare values with different dataTypes.

Please any one can help me??

[MFGF]

Hi,

Seems very odd syntax for an OLAP-type package.

Have you tried

tuple([member with ID of 16 from the package tree],[Total Cost])

MF.

[charlie]

try using 16 as '16' (in single quotes)