Bex Report

[Former Member]

Hi All ,

Help me out to get this report, where data is

Sales Order :     Order date       Delivery date

10001                   1-jan-2015     5-jan-2015

10002                    1-jan-2015     13-jan-2015

Delivery on time  condition is <=10 days

Report :

Month:            Total Orders:        Delivered on time orders:

Jan                     2                                   1

Thanks ,

Dinesh

[Loed · Accepted solution]

Hi Dinesh,

As Vengal said, you need to create two (2) formula variables for order date and delivery date with process type as replacement path..

You may check this for details:

For example, you already have two (2) formulas namely ZORD_KF and ZDEV_KF..

Create another formula, let's call it ZDEV_ON_TIME (for DELIVERY ON TIME ORDERS column) and enter this formula:

( (ZDEV_KF - ZORD_KF) <= 10) * 1 + 0

Create again a formula for total orders column, let's call it ZTOTAL_ORD, put the order date in this formula..In the AGGREGATION tab choose COUNTER FOR ALL DETAILED VALUES and REF.CHAR choose SALES ORDER..

Just post here if you have clarifications..

Regards,

Loed

[Former Member]

Thanks Everyone ,

I have got it

[former_member186053]

Hi Dinesh,

Create two formula variables for each order date and delivery date with process type as replacement path,and then create a CKF to get the difference by using these two newly created formulas.

Thanks,

vengal

[KodandaPani_KV]

Hi,

if your are using the constant vlaue in the report yes it is possible.

create the new formula -> delivared on time oreder -> put the formual inside.

hit the aggregaion tab -> select counter for all details values that are null or zero.

use the reference char -> Delivery date.

save it then execute it in the RSRT.

verify the values.

-Phani.