I have these two measures made in beast mode that looks like this:
Status
CASE WHEN `Delivery` = 'Done' THEN 'Complete'
ELSE CASE WHEN IFNULL(`Quantity`, 0) < IFNULL(`Order Quantity`,0) THEN 'Pending' ELSE 'Complete
END
Completion Percentage
(
COUNT(DISTINCT
CASE WHEN `Delivery` = 'Done' THEN CONCAT(`Company Code`, `Purchase Code`, 'Customer Code`)
ELSE CASE WHEN IFNULL(`Quantity`,0) = `Order Quantity` THEN CONCAT(`Company Code`, `Purchase Code`, 'Customer Code`) END
END)
)
/
COUNT(DISTINCT CASE WHEN IFNULL(`Quantity`,0) < `Order Quantity` THEN CONCAT(`Company Code`, `Purchase Code`, 'Customer Code`) END)
Now the problem is that as you can see, the calculation for Completion Percentage only includes Case when `Delivery` =`Done`, while in the Status, the 'Complete` status also includes the Else condition. So how do I modify the code in Completion Percentage so that the Delivery also includes the Else condition like the one in the Status?
Thanks!