Count distinct on a if-variable condition

Anonymous — Wed, 22 Dec 2021 15:42:54 GMT

Hi,

I need some help to set a formula.

I have a variable, vStock, that calculate the items stock at a given date:

SUM({$<StockDate={">=$(=MIN(DateInit))"}>*$<StockDate={"<=$(=MIN(DateEnd))"}>} Quantity )

I'm trying to count the distinct items where stock is greather than zero, for example:

COUNT DINTINCT [Item] WHERE [vStock]>0

After some research I find out this formula, but is very slow (and I don't know if it is correct):

COUNT(DISTINCT AGGR(if($(vStock)>0, Item), Item))

There is another, simple way to calculate this without Aggr and/or If statement?

Re: Count distinct on a if-variable condition

Thiago_Justen_ — Sat, 27 Jan 2018 11:44:15 GMT

Gabriele,

What about this:

Count({<ITEM={"=$(vStock)>0"}>} Distinct ITEM)

Cheers