I currently have a report that lists our Production Order numbers and then a sub list of components to each Production Order using the formula below. This has been working since the beginning of this year but just now has stopped working. Now the formula will bring in the first line only and will not bring the remaining components. I was wondering if anyone has ever had this type of instance where you had a formula working properly and all of a sudden it stopped.
=IFERROR(NL("Rows","Prod. Order Component",,"Prod. Order No.",$C$3,"Remaining Quantity",">0"),"")
The reason for the iferror was to remove the #value since it would give all my users a pop up that there was an issue with the report.