Hi, i want to show the cost of late deliveries. This is calculated by multiplying 0,75 euro for each kg which is delivered late. I have the delivered quantities (for all cases) in my table. How can i alter the formula for only late kg's

Do you have the Late Delivery activity in your activity table ?

If yes you can do the following

0.75 * SUM(CASE WHEN ACTIVITY_TABLE.ACTIVITY = 'LATE DELIVERY' THEN DELIVERED_QUANTITY END)

If no use a similar case when statement with the logic for late delivery.

Hope this helps !

Hi, late delivery is not in my table. I only have promised delivery time and actual delivery time. I used that to create a separate dimension 'late delivery', 'early delivery', and 'on time delivery'. So any ideas how i can use that to filter inside my KPI?

Already many thanks for your answer

I think i have done it. Many thanks for the help Abhishek!