Skip to Content
0
Jun 26, 2020 at 06:15 PM

buckets based on days

66 Views Last edit Jun 26, 2020 at 06:27 PM 2 rev

Hi All,

I am developing a report for the Work Items. The days between the Creation date and Action date is calculated during data load and i am using function module to exclude the weekends and holidays and i am storing it in a keyfigure during dataload in the end routine.

Now in the report(BEx ) query i need group these as

0 to 10 days ( Keyfigure with value between 0 to 10 )

11 to 50 days ( Keyfigure with value between 11 to 50 )

51 to 100 days ( Keyfigure with value between 51 to 100 )

> 100 days ( ( Keyfigure greater than 100 days)

i know at the characteristic level we can create the buckets using the offset and restricted keyfigure. But the same i need to do at the keyfigure level. Please let me know how can i do it at BEx level.