Skip to Content
Former Member
Oct 23, 2013 at 05:18 AM

AR Bex Query


Dear All,

I have configured infocube 0FIAR_C03 to would like get the below KPI

((Number of customer overdue (>30 days) invoces / Total number of ope invoices) * 100)

I have created a Formula variable on 0Netduedate & used standard 0F_KEYDT to get the current system date.

0F_KEYDT - 0NETDUEDATE gives me the diff in days.

How do I get the count of invoice which are more than 30 days kindly advise.

Thanks a lot