I have two columns:
Column E =NL("Rows","Posted Work Order Line","Vessel Code")
and
Column F =NL("Last","Posted Work Order Line","After Volume","Vessel code","@@"&$E9)
Then I'm conditionally hiding the rows where column F, After Volume = 0. How can I combine the two functions into one, to filter out records where the After Volume <> 0 so I do not have to hide rows?
It appears that you are using Dynamics NAV.
In that case, the filter is almost identical to that used in the Sort by Sum or Count technique. Instead of filtering by "*" you would filter by ">0"
Something like this:
=NL("Rows","Posted Work Order Line","Vessel Code","=NL(""Last"",""Posted Work Order Line"",""After Volume"",""Vessel code"",NF(,""Vessel Code""))",">0")
Harry, this was very helpful. Thank you!