Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
i have an expression to give the amount in purchasing for purchaseorders placed between 2 certain dates:
=Sum({1<SupplierOrderDate={">=$(=minDatumHuidigAankoopseizoen)<=$(=maxDatumHuidigAankoopseizoen)"}>}(SupplierOrderPriceNetDefaultCurrency * SupplierOrderQtyOrdered))
How should i make the expression to count how article numbers are involved?
i tried this:
=count ( distinct {1<SupplierOrderDate={">=$(=minDatumHuidigAankoopseizoen)<=$(=maxDatumHuidigAankoopseizoen)"}>}SkuCode)
but this does not seem to work...
any ideas ?
thanx
Chris
¨Pretty difficult to diagnose with just a couple of expressions that look OK. Would it be possible for you to post an example document with which you are having this same problem?
Hey Peter,
i made an example document.
in the table on the right with the orange header i have a count for the SkuCode, but it gives me 70 SkuCodes and in the table on the left side it clearly are not so much articles.
For example "Cutlery" on the left has 1 SkuCode , but on the right 5...