Hi,
I'm using the following to try and sort customer balances into aged categories in different columns:
=NL("Sum","Cust. Ledger Entry","Remaining Amount","Company=",$C$2,"Customer No.",$F13,"Document Date","<C10")
The formula returns a zero, however it will return the correct value if I use the following and actually type a date rather than a cell reference for document date:
=NL("Sum","Cust. Ledger Entry","Remaining Amount","Company=",$C$2,"Customer No.",$F13,"Document Date","<05/05/2021")
Any ideas why it doesn't like a cell reference in the formula? Is there an alternative method?
Many thanks in advance
M