I have two Time Periods, one the In time and the Oher the Out time. I have created a master sheet with the time frame and linked it with the table as 2 different time periods. Now i need make the two windows common to calculate a value using the values from these two window frames. Order is a common field which denotes the order of the time frame. I have used Interval Match to get values from the main table..
This is exactly what I wanted, but sorry that my table data had count in it. My count is not in the same table, that also has to be calculated from another table and then joined with the time table. Then how would I need to write the expression??