0

Greater Than Filter

I have the following NL Function, from this I have a cell that contains an NF Function to get the Sum of two amount values from the NL Rows.

=NL("Rows","Sales Header",,"+Rental Start Date",B12,"Location Code",C12,"No.","RO00000..RO99999","Venue Referral","True")

=NF($D12,"Rental Amount")+NF($D12,"Amount")

$D12 is the cell reference of the above NL.

I want to create a filter in the NL Rows Function that returns only values that are >=20000

How can this be achieved please? Note there is not a Table field that is the sum of these two already otherwise I would just filter on that.

 

2 comments

Please sign in to leave a comment.