what's wrong with this formula?
Content
Trying to get the percentage of applicants who haven't been moved in more than 14 days, individually the counts work fine, but when I try to divide it gives me zero's.
COUNT(DISTINCT CASE WHEN (TIMESTAMPDIFF(SQL_TSI_DAY,"Submission CSW Status - Current"."Current Status Start Date", CURRENT_TIMESTAMP)) > 14 THEN "Submission General Info"."Submission Identifier" END)/COUNT(DISTINCT "Submission General Info"."Submission Identifier")
Tagged:
0