Skip to main content
Hey all, I want to count cases where an article number is just present in one table but not in the other example TableV1 ArtNr 1 3 4 5 7 9 TableV2 1 2 3 4 5 6 7 8 9 10 Count cases which are in TableV2 but not in TableV1 (Null). In that case 2, 6, 8, 10 -> Count = 4 Thx and br Daniel
Dear Daniel, thanks for reaching out to the Celonis Community Forum! Try using the formula: SUM(CASE WHEN ISNULL(TableV2.ArtNr)=0 AND ISNULL(TableV1.ArtNr)=1 THEN 1.0 ELSE 0.0 END) This works as soon as there is a common primary key in both tables. Feel free to follow up with any additional questions. Best regards, your Celonis Community Forum Team
Community Code of ConductAccessibility statement