Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am using rangesum for the counting the expression in trend chart.
rangesum(above(Sum({<Equipment_isSMA_Upgrade_Eligible={1},Flag={2},MonthYear=,QuarterYear=>}if(EquipmentStartYear<= Year,EquipmentCount)),0,RowNo())))
but when i am selecting any year the values are getting changed ....which is not required by business.
Can anyone help me in finding the alternate solution for this?
sorry it does not make any difference but still many thanks for help
IT WORKED Many thanks .......just need to remove flag =2 in average expression