0

NL Filter Request Delivery date

Samer Baskhayroun

April 29, 2020 16:44

None

Follow

i tried to requested delivery date as a filter but i got the following error

i use that formula

 

=@NL("sum","Sales Line","Quantity","No.",$D12,"Requested Delivery Date",Options!C4,"Document Type","Order")

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Bryan Robinson May 11, 2020 13:06

  You are missing an absolute reference to your date filter, that is why it works on the first row and fails on all the subsequent rows, as the reference moves to C5, C6, C7...

  =@NL("sum","Sales Line","Quantity","No.",$D12,"Requested Delivery Date",Options!$C$4,"Document Type","Order")