cancel
Showing results for 
Search instead for 
Did you mean: 

Is there an argument limit for FIRSTNONBLANK?

Highlighted
NiCd Battery
Hi everybody!

I had a question about the FIRSTNONBLANK equation to make a new row.  I have used it very effectively but I sent it to a colleague to share for a similar piece of work.  The equation being used is 

FIRSTNONBLANK( @LOB1@ , @LOB2@ , @LOB5@ , @LOB4@ , @LOB3@  )


But it's only returning the data for @LOB1@ and none of the others.  The logic seems right and like it should be working.  Please share any advice or thoughts you may have.

Labels (1)
0 Kudos
3 Replies
Highlighted
Linear Actuator
Hi JRood, the equation should be fine for the five columns you reference (not a limitation). However, would you mind posting back the actual column names that your colleague has in his/her dataset?
thank you
0 Kudos
Highlighted
NiCd Battery
Those are the actual column names used.  It looks like they eventually got it to work; I went in and the formula still looks pretty much the same.

FIRSTNONBLANK(@LOB1@ ,@LOB2@ ,@LOB3@ ,@LOB4@ ,@LOB5@ )  

Again, these are the actual column names.  Not sure why this worked when the previous didn't. 
0 Kudos
Highlighted
Linear Actuator
Glad to hear all is working. Please let your colleague know that Pax Pros are standing by here in the Community if any other issues arise :) 
0 Kudos