Best way to populate null as Zero while using Aggr() and count

[chaper]

I am trying populate (not just show) null values as Zero while using Aggr().Tried if condition but no luck.

aggr((count({<Fiedl1={'2016'}>}Distinct Field2)),Field3)

Thanks

[vishsaggi]

May be this?

Alt(aggr((count({<Fiedl1={'2016'}>}Distinct Field2)),Field3), 0)

[sunny_talwar · Accepted solution]

Or just this

Sum(Aggr((Count({<Fiedl1={'2016'}>}Distinct Field2)), Field3))

[chaper]

Thanks Sunny and Vishwanath .Both solutions work perfect

[chaper]

Your solution works perfect but Totals not populating.

[chaper]

Sunny your solution works and also shows right totals on top.Thanks