check if a parameter value is numeric

[manu0521]

Pass a cell value from excel to tm1 ti process.

User can enter any value and submit an action button , in ti ,I have to check if the passed value is numeric .

Is there a function in tm1 which can check if the parameter value is numeric.

Thanks,

[tomok]

User can enter any value

Not if you apply data validation in Excel.

[macsir]

Better than nothing

Code: Select all

SCAN( SUBST( vsVar, 1, 1 ), '0123456789' ) <> 0

[Alex Leung]

Set the parameter as string type first, then add checking as below:

Code: Select all

IF( vsVar @= NumberToString( NumBr ( vsVar)) );
#Is Numeric
Else;
#Not;
EndIf;

Alex

[Mark RMBC]

Hi,

I would think Tomok's suggestion is the way to go, but

Cant you just do the check in Excel, so have a formula along the lines of:

=IFERROR(A1*1,0)
=IF(A2=0,0,1)

Then have a parameter in the TI called pIsNumeric (1 or 0) and have the action button point at this cell?

regards,
Mark

[gtonkin]

Or you could use =ISNUMBER() assuming you are not using TM1 Web.

[Mark RMBC]

Yes, I originally had isnumber in my comment but then thought it is probably for the web so changed it!

[Andy Key]

You still need to change it if you're on 2.0.6 or earlier.

IFERROR only got TM1Web support in 2.0.7.

[Mark RMBC]

Yes, and in that case just use if iserror!

regards, Mark

[orlando]

Is there a function in tm1 which can check if the parameter value is numeric.

here's my idea.
Why don't you store the value in a cube (eg. Value_Input) per user.
For example, the cube could have the dimensions }Client and Measure_Input.
The elements for the input are created in the dimension Measure_Input.
Instead of passing the value to the process, the user and the element from Measure_Input are passed to the process.
The process then collects the value form the cube.
This ensures that no nonsense goes to the process and you can see what exactly the user entered last.
The input cube can of course have other dimensions, it was just a quick idea.

best regards
orlando