Doing Expression Calculation in the Script and using aggregation table(using resident)

[#1]

Hi All

How to do the below calculation in the script level which I am doing it in the expression? I am trying to do this as the performance is poor when I am doing it in the front end.

SUM(IF(StartDate<=date AND EndDate>=date,1))

For your information, Fields ImplStart and ImplEnd are loaded from table 'Data' and 'date' is getting loaded from another table called 'Calendar'

I thought of creating the aggregation table but the problem is data is getting loaded from two tables. So I dont know how to use the 'Resident' to load data from two tables.