cancel
Showing results for 
Search instead for 
Did you mean: 

firstnonblank(@number1@, @number2@) doesn't work

stephexcel2004
Blue LED

firstnonblank(@number1@, @number2@) doesn't work

I got this error when using:

number1/FIRSTNONBLANK(number2, number3)

 

Expected Number type, got Text

 

DataRobot Paxata 2021.2 Release

 


 

Release: 2021.2.4.3.2858

 

Interface: 2021.2.4.3.2858 - 2021.2.4.3.2858

 

Pipeline: 2021.2.4.3.2858 - 2021.2.4.3.2858
0 Kudos
2 Replies

All numbers.

It does not work for formulae below:

@number1@ /FIRSTNONBLANK(@number2@ ,@number3@ )

 

But, work if calculated separately:

calc1 = FIRSTNONBLANK(@number2@ ,@number3@ )

 

calc2 = @number1@ /@calc1@@

0 Kudos
Bogdan Tsal-Tsalko
Data Scientist
Data Scientist

Hi stephexcel2004

May I ask you to check if the number1\number2\number3 column types are numeric? Your error might happen due to non-numeric values, most commonly it happens when "Nan" - is a string value instead of missing one.
If this will not solve your problem - please reply here, and add some screenshots of columns EDA and error.

0 Kudos