Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello.
I have a problem. I need to count the number of unique items in each store, thus it is necessary to consider only those products whose number is greater than 0 (>0). The document, which is attached as an attachment, at the level of display products level everything works right, but to collapse the network level, the data is displayed incorrectly.
Help me please to solve this problem.
Try this:
Sum(Aggr(If(Sum(Amount) > 0, Count(DISTINCT Product)), Product, Shop))
Try this:
Sum(Aggr(If(Sum(Amount) > 0, Count(DISTINCT Product)), Product, Shop))
May be use this
Sum(If(Sum(Amount) > 0, Aggr(Count(DISTINCT Product)), Product, Shop))
Thank you