I would like to extract the quantity on hand on a date with the lot number. I uses the formula
@NF($D6,"Net Change","Date Filter",NP("DateFilter",,$G$3))
Being D6 is the NL("Rows","Item") and G3 is the date.
But I could not extract the lot number that contain the balance. Any solution?