Hi,
This is my code called Cost. I added a filter to show only entries where the cost is null, but it still shows entries with values.
SUM(PU_SUM(o_CELONIS_SALESORDERITEM, "o_custom_CostPerLine"."CostTransactionCurrency",
"o_custom_CostPerLine"."CostElement" IN ('00004', '40020', '400100', '40220'))
/"o_celonis_SalesOrderItem"."OrderedQuantity"
*"o_custom_CustomerFinanceDocumentItem"."Quantity"
+COALESCE(PU_SUM(o_CELONIS_SALESORDERITEM, "o_custom_CostPerLine"."CostperQuantityTransactionCurrency",
"o_custom_CostPerLine"."CostElement" IN ('46100'))/"o_celonis_SalesOrderItem"."OrderedQuantity"*
"o_custom_CustomerFinanceDocumentItem"."Quantity",0))
my Filter :
Filter (exactly the cost code) is null
Thank you for your help