Buckets in Report

[Former Member]

Hi BW Experts,

I have a problem with my Ageing Report.

In MM, we have developed one report i.e, " PO Created After Receipt Of Materials".

Our Report Skeleton.

........................................................................................................

AGEING, NO.Of POs, As a %, Value Of POs, As a%,

........................................................................................................

0-30, 683, 66%, 11,981, 75%

30-45, 225, 22%, 3,058, 19%

45-60, 63, 6%, 590, 4%

60-90, 57, 6%, 260, 2%

.............................................................................................................

Grand Total 1028, 100%, 15,888, 100%

.............................................................................................................

I have got the date difference (By Subtracting 2 Date fields) is nothing but a AGEING. Now i want to put the AGEING in Buckets like 0-30, 30-45, 45-60, 60-90.

But iam unable to put the AGEING in Buckets, (Here AGEING is nothing but a Time Difference between 2 dates ) .

I got the Time Difference (AGEING) by using REPLACEMENT PATH Variables.

Please can anyone help me.

Thanks in advance.

Regards,

Anjali

[former_member184494]

Anjali,

Create formulae for the same with an If condition.

and then you can have as many buckets as you want.

Arun

[Former Member]

Hi Arun,

Thanks for the reply.

Can u please tell me, how to write the IF condition in formula.

Please give me the reply.

Regards,

Anjali

[former_member184494]

A typical example would be

(<KF> <logical operator > <value>) +

ex :

(salesval > 100) + 0

this would output 1 if the condition is satisfied or give a 0.

to use this further you may use :

(salesval > 100)*10 + 20

here the values will be 10 for true and 20 for false..

Arun

P.S search the forums for conditional IF statements