Forum Stats

  • 3,853,958 Users
  • 2,264,299 Discussions
  • 7,905,517 Comments

Discussions

PBCS - Convert Alias into Numeric Value

Nuno_Antunes
Nuno_Antunes Member Posts: 17
edited Jun 27, 2018 5:20AM in Planning and Budgeting

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

Tagged:

Best Answer

Answers

This discussion has been closed.