Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
can any tell me what is wrong with this expression?
It is not limiting data where APInvDist.PODistributionId is less than 1?
=count(DISTINCT {<[ACCHier Description4]={"NON PAY"},APInv.CreationDate={"$(= '>=' & '01/04/2015' & '<=' & '31/03/2016')"},APInvDist.PODistributionId={"<1)"}>}[APInv.InvoiceId])
thanks in advance
It seems like you have a bracket out of place at the end:
"<1)" should be "<1"
and I would put square brackets around the field names in the set expression too...
Hi, thanks for that.
I still seem to be having a problem though counting distinct?
I am counting distinct [APInv.InvoiceId] but it is counting the lines rather than invoice unless I select the invoice and then it counts correctly.
any ideas?
The field [APInv.InvoiceId] might be not the invoice# - it could actually be an unique identification of each line accross all invoices.
So check if you have an "Invoice Number" that you can count distinct instead ....