display null as zero for aggr

[Anonymous]

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 ?

[Kushal_Chawda · Accepted solution]

You need to use aggregation function to use AGGR

aggr(if(sum(Stock) = 0, [Code Article]),[Code Article])

[sunny_talwar]

Another option is to use this:

=Aggr(Only({<[Code Article] = {"=Sum(Stock) = 0"}>} [Code Article]), [Code Article])