I would like to show rows in the Rental Line table where the Unit Price field is < the Price Field in the Rental Price table.
I know how to link the two tables, but I don't know how to handle the < expression.
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi,
I don't have your custimization of NAV so I don't know what the field is that connects the Rental Line and Rental Price tables is, but I'll give it a shot. You need a calculated filter something like this:=NL("Rows","Rental Line",,"Unit Price","=""<""&NL(,""Rental Price"",""Price"",""Rental No."",NF(,""No.""))")
So in this example I'm assuming that there is a field named No. on the Rental Line table which matches the field named Rental No. on the Rental Price table. You may have to adjust this example for the real linking field names on those 2 tables. Does this make sense to you?
Regards,
Hughes
Please sign in to leave a comment.