The app would not run and told users to contact the developer,.
Extensive troubleshooting found a space had been added to similar expressions for 6 virtual columns. Here is the error:
Column Name ‘PTO Used’ in Schema ‘Employees_Schema’ of Column Type ‘Decimal’ has an invalid app formula ‘=SUM(SELECT( TimeReports[Hours_Worked],AND([EmployeeID] = [_THISROW].[ EmployeeID],[Task]=“PTO” ) ))’. Error in expression ‘[_THISROW-1].[EmployeeID].[ EmployeeID]’ : Unable to find column ’ EmployeeID’
Looking at Copy26Sep2020 test version of TT Admin, it is running without errors.
PTO Used (Decimal)
SUM(SELECT(TimeReports[Hours_Worked],AND([EmployeeID] = [_THISROW].[EmployeeID],[Task]=“PTO” ) ))
Prod is
SUM(SELECT( TimeReports[Hours_Worked],AND([EmployeeID] = [_THISROW].[ EmployeeID],[Task]=“PTO” ) ))
Note there is a space infront of the E. This is the case in all 6 virtual columns. I fixed all of these and we are good!!
LinkedIn
Twitter
