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)