I have this Expression at the front end . i'm trying to do all this calculation at the backend, any idea how should i proceef
if(count(distinct if([ Measure Code] = 'EI' and [Measure Date] >= Today()-$(LookbackDays) and [Measure User ] = '$(User)',[Measure Site Co]))= 0,0,
if(sum(if( Measure Code] = 'EI' and [Measure Date] >= Today()-$(LookbackDays) and [ Measure User ] = '$(User)' and Upper(Text([Measure Control]))<> 'N',[ Measure Population]))<>0,
1-(sum(if([Measure Code] = 'EI' and [Measure Date] >= Today()-$(LookbackDays) and [Measure User ] = '$(User)' and Upper(Text([Measure Control]))<> 'N',[Measure Exceptions]))
/sum(if([HM Measure Code] = 'EIM08' and [Measure Date] >= Today()-$(LookbackDays) and [Measure User] = '$(User)' and Upper(Text([Measure Control]))<> 'N',[Measure Population]))),0))
*$(EIM08DW)
+
if(count(distinct if([Measure Code] = 'ESM04' and [Measure Date] >= Today()-$(LookbackDays) and [Measure User ] = '$(User)',[Measure Site ]))= 0,0,
if(sum(if([Measure Code] = 'ESM04' and [Measure Date] >= Today()-$(LookbackDays) and [Measure User ] = '$(User)' and Upper(Text([Measure Control]))<> 'N',[Measure Population]))<>0,
1-(sum(if([Measure Code] = 'ESM04' and [Measure Date] >= Today()-$(LookbackDays) and [Measure User Type] = '$(User)' and Upper(Text([Measure Control]))<> 'N',[Measure Exceptions]))
/sum(if([Measure Code] = 'ESM04' and [Measure Date] >= Today()-$(LookbackDays) and [Measure User Type] = '$(User)' and Upper(Text([Measure Control]))<> 'N',[Measure Population]))),0))
