Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
I need to write a set analysis expression using addmonths? Below is my expression that i want to convert using set analysis
if(
count(aggr(if(1- (sum(if(MonthName(AddMonths(Today(),-2),0)=PERIOD_NAME,CUSTOMER_IMPACT_MINS))/
sum(if(MonthName(AddMonths(Today(),-2),0)<=today(),MINS_IN_MON)))<=Only({<PERIOD_NAME=,[Business Area]=,Application=>}[Theshold numeric]),[Service Id]),[Service Name]))= 0,'No Service missed SLA',
count(aggr(if(1- (sum(if(MonthName(AddMonths(Today(),-2),0)=PERIOD_NAME,CUSTOMER_IMPACT_MINS))/
sum(if(MonthName(AddMonths(Today(),-2),0)=PERIOD_NAME,MINS_IN_MON)))<=Only({<PERIOD_NAME=,[Business Area]=,Application=>}[Theshold numeric]),[Service Id]),[Service Name])))
If statements with else branches cannot be converted to set analysis statements. Sets are sets, not alternative execution paths.