0

Filter articles with quantity <>0 on two posting dates

Anna Detert

August 12, 2020 10:21

None

Follow

Hi,

I would like to to show only articles which have a stock quantity <>0 on one or another date. How could I filter these articles?

Greetings,

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  j2associates September 23, 2020 20:09

  Put your 2 dates in the options area and combine them with an Excel formula =$D$4 & "|" & $D$5. It will look funky because of the lack of formatting but it will work. Ensure Posting Date and Stock Quantity exactly match the field names that you are using to filter. Then in your NL Rows function, include the Filters= and that should work. Good luck!

              Column C           Column D      Column E    Column F
  Row 4  Date 1               07/22/2013
  Row 5  Date 2               08/02/2013
  Row 6  Posting Date     41477|41488
  Row 7  Stock Quantity  <> 0
  Row 8
  Row 9                                                                        =@NL("Rows","Your Table",,"Filters=",$C$6:$D$7)

  Note that the Filters are only Rows 6 & 7. Do not include Rows 4 & 5 because they are combined together in Row 6.

  Edited by j2associates September 24, 2020 20:12
• 0
  
  Anna Detert December 28, 2020 14:33

  Hello,

  thank you for your solution. I think it do not fit really.

  I would like to show all artikels, which have a quantity on one specifc date. So I need to make a sum of the item ledger entries and will only show items which have a quantity. My idea was to make the following filter: 

  ||"Filter","Item","1 No.","NL(""Sum"";""32 Item Ledger Entry"";""12 Quantity"";""3 Postingdate"";""..28.12.2020"";""Itemno_."";NF(;""1 No.""))",">0"

   

  But this do not work...