0

NL(Count) if Filter 1< Filter 2

Tim Pawlak

August 15, 2017 14:56

None

Follow

Hallo,

i want to count all rows of a table where the condition: Promies Receipt Date < Document Date is true.

My approch was this:

It does not work.

Has anybody an idea how i can solve this problem?

Thanks in advance

 

• Facebook
• Twitter
• LinkedIn

1 comment

• 1
  
  JaeW_atOnyx August 22, 2017 23:23

  The reason this doesn't work is twofold.

   

  Your IF statement (even if it properly returns Promised Receipt Date and Document Date) does not resolve as an Excel function.  Imagine if in Excel you typed =If(1/1/2017=2/1/2017) , you'd need to finish the function.

   

  Furthermore, you're trying to FILTER rows from the Purchase Header.  So you need to put in filters on your NL("count") function.

  You need something like: NL("Filter", "Purchase Header",,"Promised Receipt Date", ">"&nf(,""Document Date"")")

   

  I did a tutorial on calculated fields in Jet Professional here:

  http://www.onyxreporting.com/blog/the-elusive-sort-on-sum

   

  Good luck!

  Jae@OnyxReporting.com