Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying (and failing) to change this expression into set analysis. Can anyone help?
if(addmonths(makedate(2015,1,1),max(i))<today(),
rangesum( Above(Sum(if((month([Closed Date])+year([Closed Date])*12)-year([Loss Date])*12=i and [Loss Year]=2015,if(Status='Closed',TPI_Inc))), 0, rowno() ))
/rangesum( Above(count(Distinct(if((month([Closed Date])+year([Closed Date])*12)-year([Loss Date])*12=i and [Loss Year]=2015,if(Status='Closed',[MJCNFH Application ID])))), 0, rowno() ))
,null())
Thanks
Do you have a sample where we can play around with this?