Hi there!
I have a little problem here with a single KPI. What I have are two tables (Sales Document Header VBAK, Sales Document Item VBAP).
Only the VBAP includes a column with cancellation reasons (which are always the same for one sales document). The offer is still open, if the cancellation reason is null.
However, I dont know how to calculate the ratio of open offers, but only for the VBAK table/ VBAK.VBELN (just for the headers, not for every item). I could only create a OLAP table with the VBAK.VBELN and the cancellation reasons by clicking on distinct values in the advanced options.
I tried different PU functions to join the tables and the filter ISNULL, but did not succeed
Any help is highly appreciated. Thanks!
Best regards
Page 1 / 1
I have something similar to your requirement. you can check if this one helps:
AVG(
CASE WHEN
PU_COUNT_DISTINCT(VBAK, VBAP.POSNR) = PU_COUNT(VBAK, REMAP_VALUES(VBAP.ABGRU, [ , NULL]))
THEN 1.0 all order line items are rejected
ELSE 0.0 at least one order line is not rejected/cancelled
END
)
AVG(
CASE WHEN
PU_COUNT_DISTINCT(VBAK, VBAP.POSNR) = PU_COUNT(VBAK, REMAP_VALUES(VBAP.ABGRU, [ , NULL]))
THEN 1.0 all order line items are rejected
ELSE 0.0 at least one order line is not rejected/cancelled
END
)
Thanks a lot! That actually helped 
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.