Hello,
Using Dynamics NAV, I need to filter for Quantity > Finished Quantity. I get an error when I try to use "Quantity" and ">Finished Quantity" in an NL Function Filter. How do I compare two fields in an NL Filter?
Date
Votes
1 comment
-
Harry Lewis Something like this, perhaps?
=NL("Rows","my_table",,"Quantity","=""NUMBER&>""&NF(,""Finished Quantity"")")With Dynamics NAV, we can use the NF() function within a filter to return a comparison value from the record.
Because all filters (including this NF() function) must be contained within quotation marks, Excel considers the value returned to be text (not a number). Since we want to perform a numeric comparison with that value, we need to force Excel to treat it as a number by using the NUMBER& technique.
Please sign in to leave a comment.