Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Month | Level | YTD Attrition Count |
Apr | Manager | - |
May | Manager | 1 |
Jun | Manager | 2 |
Jul | Manager | 5 |
Aug | Manager | - |
Sep | Manager | -5 |
Oct | Manager | - |
Nov | Manager | - |
Dec | Manager | - |
Jan | Manager | - |
Feb | Manager | - |
Mar | Manager | - |
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))
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)