Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
banjo255129
Contributor
Contributor

Replace null values with 0 through expression

Want to Replace null values with 0 through expression .

It has two dimensions and for second dimension some values are missing.

Need accumulated value from April to Max month.

Below is the expressions  -

=Aggr(Rangesum(Above((Count({<Attr_Flag={1},Year={'$(vMax_Year)'},[Month ID]={'<=$(vMax_MonthID)'}>}DISTINCT [Employee Code])),0,RowNo())),Level,Month)

MonthLevelYTD Attrition Count
AprManager-
MayManager1
JunManager2
JulManager5
AugManager-
SepManager-5
OctManager-
NovManager-
DecManager-
JanManager-
FebManager-
MarManager-
2 Replies
Gysbert_Wassenaar

Perhaps like this:

sum(Aggr(Rangesum(Above((Alt(Count({<Attr_Flag={1},Year={'$(vMax_Year)'},[Month ID]={'<=$(vMax_MonthID)'}>}DISTINCT [Employee Code]),0)),0,RowNo())),Level,Month))


talk is cheap, supply exceeds demand
sunny_talwar

May be one of these:

=Sum(Aggr(Rangesum(Above((Count({<Attr_Flag={1},Year={'$(vMax_Year)'},[Month ID]={'<=$(vMax_MonthID)'}>}DISTINCT [Employee Code])),0,RowNo())),Level,Month))


or


Alt(Aggr(Rangesum(Above((Count({<Attr_Flag={1},Year={'$(vMax_Year)'},[Month ID]={'<=$(vMax_MonthID)'}>}DISTINCT [Employee Code])),0,RowNo())),Level,Month), 0)