Skip to Content
0
Former Member
Sep 07, 2006 at 05:26 PM

0FIAP_C03 Cash Mgmt Amounts into Due Date Buckets

28 Views

Using Cube 0FIAP_C03 A/P Payables in BW3.5 and Query Designer. I have a need to take the open items and ‘group’ them by days past due.

First step I created a new key figure to take today’s date (key date) and subtract the net due date. This provides a numeric value of the days past due. So far, so good.

Then I created another key figure that was the days past due divided by 7 and I displayed the output with zero decimals. This appears to get the buckets, but I can’t find a way to display/group the amount by these buckets for the report. But I can’t find a way to get the Amount (doc currency) to show in buckets (columns) like current, 1-7 days past, 7-14, etc.

All thoughts appreciated, I may of headed in the wrong direction when there is another approach. Thanks.