I am trying make a resident table out of a table whose data comes from another resident table, and I'm getting an error. Here's my simplified data structure:
From [file location];
NetWorkDays([Pre-Processing],[Processing]) AS [Pre-Processing Speed],
NetWorkDays([Processing],[Underwriting]) AS [Processing Speed],
NetWorkDays([Underwriting],[Closed]) AS [Underwriting Speed]
DROP TABLE [Dates];
If([Pre-Processing Speed]<10,[Pre-Processing Speed],10) AS [Pre-Processing Speed],
If([Processing Speed]<10,[Processing Speed],10) AS [Processing Speed],
If([Underwriting Speed]<5,[Underwriting Speed],5) AS [Underwriting Speed]
DROP TABLE [Speed];
As far as I can tell, there shouldn't be an issue, but when I load the data, no "Speeds" show up at all. If I take away the [Refined Speed] table, it works just fine, but I need there to be a ceiling for the speeds (to get rid of outliers).
Unfortunately, my data is a little more complex and thus cannot be loaded by a single statement. However, the rangemin() function allowed me to combine the second and third tables in a way that gets rid of the error I was facing. Thanks!