Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the following expression
=if(AGGR(Stock, [Code Article]) = 0, [Code Article])
I need to display code Article for which stock =0 or stock is null, how to correct it ?
You need to use aggregation function to use AGGR
aggr(if(sum(Stock) = 0, [Code Article]),[Code Article])
You need to use aggregation function to use AGGR
aggr(if(sum(Stock) = 0, [Code Article]),[Code Article])
Another option is to use this:
=Aggr(Only({<[Code Article] = {"=Sum(Stock) = 0"}>} [Code Article]), [Code Article])