I have a trellis chart with Sum(Amount) which represents yearly sales as an expression. The application is attached.
I using the following expression to calculate the MAT for each applicant:
if(Year = 2015,Num(sum({<[Date Dispensed]={">=$(=addmonths(MonthEnd(max([Date Dispensed]))+1,-12)) <=$(=max([Date Dispensed]))"}, Applicant = {[SANOFI AVENTIS], GLAXOSMITHKLINE, PFIZER, NOVARTIS, [TORRENT],[NOVO NORDISK], RANBAXY, IPCA, ALCON, GLENMARK, MYLAN, VARICHEM, [CIPLA], ALLERGAN}>}[MedAid Amount]+Shortfall), '$##,##0.00'), if(Year = 2014, Num(sum({<[Date Dispensed]={">=$(=addmonths(MonthEnd(max([Date Dispensed]),)+1,-24)) <=$(=addmonths(MonthEnd(max([Date Dispensed])),-12))"}, Applicant = {[SANOFI AVENTIS], GLAXOSMITHKLINE, PFIZER, NOVARTIS, TORRENT,[NOVO NORDISK], RANBAXY, IPCA, ALCON, GLENMARK, MYLAN, VARICHEM, [CIPLA], ALLERGAN}>}[MedAid Amount]+Shortfall), '$##,##0.00'), if(Year = 2013, Num(sum({<[Date Dispensed]={">=$(=addmonths(MonthEnd(max([Date Dispensed]),)+1,-36)) <=$(=addmonths(MonthEnd(max([Date Dispensed])),-24))"}, Applicant = {[SANOFI AVENTIS], GLAXOSMITHKLINE, PFIZER, NOVARTIS, TORRENT,[NOVO NORDISK], RANBAXY, IPCA, ALCON, GLENMARK, MYLAN, VARICHEM, [CIPLA], ALLERGAN}>}[MedAid Amount]+Shortfall), '$##,##0.00'))))
I am getting some results which are however lower than expected. Can any one look at the above expression and application and advise accordingly.
Message was edited by: Christopher Chitemerere
