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
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
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!