0

An array is not a valid argument

Yvonne Jury

January 31, 2018 21:02

Answered

Follow

The formula below is returning the error, "An array is not a valid argument for the FilterField parameter of this function".

The OR is what's causing the error, because if I remove the OR to only use one of the filters within it, it works fine. 

=nl("Rows","Posted work order line",,"=OR(NF(,""Current Batch Owner"")=""AGVAP"",NF(,""New Batch Owner"")=""AGVAP"")","+Work order date",$C$3,"+=IF(nf(,""4"")=""RELEASE"",(IF(nl(""First"",""16020671"",""199"",""1"",nf(,""1""),""2"",""From"")=0,99999,IF(nl(""First"",""16020671"",""199"",""1"",nf(,""1""),""2"",""From"")<>0,nl(""First"",""16020671"",""199"",""1"",nf(,""1""),""2"",""From"")))),nl(""First"",""16020671"",""199"",""1"",nf(,""1""),""2"",""To""))","*","Filter=",$B$4:$C$8)

I don't want to use NP Union because then I lose my sorting.

 

 

 

 

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Harry Lewis January 31, 2018 21:18

  Hi Yvonne -

  What exactly are you trying to do with this OR?

  

   

• 0
  
  Yvonne Jury January 31, 2018 21:29

  I got it...!

  =nl("Rows","Posted work order line",,"=OR(NF(,""Current Batch Owner"")=""AGVAP"",NF(,""New Batch Owner"")=""AGVAP"")","@TRUE","+Work order date",$C$3,"+=IF(nf(,""4"")=""RELEASE"",(IF(nl(""First"",""16020671"",""199"",""1"",nf(,""1""),""2"",""From"")=0,99999,IF(nl(""First"",""16020671"",""199"",""1"",nf(,""1""),""2"",""From"")<>0,nl(""First"",""16020671"",""199"",""1"",nf(,""1""),""2"",""From"")))),nl(""First"",""16020671"",""199"",""1"",nf(,""1""),""2"",""To""))","*","Filter=",$B$4:$C$8)

   

   

  Edited by Yvonne Jury January 31, 2018 21:35