Hi All,

I have this Calculated Member:

iif( [Measures].[Codigo Data Venc Titulo] <> NULL,
right([Measures].[Codigo Data Venc Titulo],2) + "/" +
Mid([Measures].[Codigo Data Venc Titulo], 5, 2) + "/" +
left([Measures].[Codigo Data Venc Titulo],4) ,
NULL
)

But it doesn't work....only if I change "NULL" for Empty string ("").

iif( [Measures].[Codigo Data Venc Titulo] <> NULL,
right([Measures].[Codigo Data Venc Titulo],2) + "/" +
Mid([Measures].[Codigo Data Venc Titulo], 5, 2) + "/" +
left([Measures].[Codigo Data Venc Titulo],4) ,
""
)

Anyone has an idea??

Thanks,

=================================
Cristiano Moraes da Silva
DBC Database Company
Porto Alegre - RS - Brasil
+55 513330 7777
cristiano (AT) dbccompany (DOT) com.br
www.dbccompany.com.br

There is a well-known issue when combining a string with NULL in iif(),
which you may be encountering. Using a second measure to "hide" the text
may work, like:

[Measures].[Text1] :
Mid([Measures].[Codigo Data Venc Titulo], 5, 2) + "/" +
Left([Measures].[Codigo Data Venc Titulo],4)
[Measures].[Text2] :
NULL, [Measures].[Text1])

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***