You are viewing an old version of this page. View the current version.
Compare with Current View Page History
« Previous Version 4 Next »
If you don't need to have colorful statuses in the Time Evaluation column, don't add this single column table.
Use the following SQL query:
SELECT *, CASE WHEN 'Sum of Time Spent' > 'Sum of Original Estimate' THEN "OVERDUE" ELSE "IN TIME" END AS 'Time Evaluation' FROM T1