PBCS - Convert Alias into Numeric Value

Nuno_Antunes

Hi,

I'm using the alias table to make a mapping for an IF statement, but when I do the condition, it return error in validation because the function is expecting a numeric but the function alias return a string.

Here is the example:

IF ("INI_ANO_CONT" == @ALIAS(&Ano_Rea,"Mapping")

“INI_ANO_CONT” is a member;

&Ano_Rea is an substitution variable

There is any way to transform the alias function into numeric, or there is any other way to do this condition?

Thanks,

Nuno

user9928941

Hi,

To compare the strings, you can use the CDF @calcmgrcompare.

If you want to assign the value of the member being used with the "Substitution variable", you can use @Member around @Alias to get the value.

Thanks,

Pawan.

hakris

Hi,

Are you trying to compare the member names or values?

Thanks,

Nuno_Antunes

Hi,

I'm trying to compare the value, because that member has a smartlist behind and i'm trying to mapping the smartList ID with the alias.

Thanks,

Nuno

user9928941

Hi,

To compare the strings, you can use the CDF @calcmgrcompare.

If you want to assign the value of the member being used with the "Substitution variable", you can use @Member around @Alias to get the value.

Thanks,

Pawan.

Nuno_Antunes

Hi

I used the @calcmgrcompare to compare the strings, just needed to convert the value of the “INI_ANO_CONT” to string to be comparable.

Thanks,

Nuno