Need help??

[qv_testing]

Hi Community,

I have one requirement....

suppose i have a Days.. like..

These are my input fields...

Ex:    Start_day                 End_Date

           10                            30

           31                            45

           45                            60                                  Generate Report

If i am click generate report button i want to generate report based on input dates....  Customer and SalesPerson standard fields...

Like this

Custmer            SalesPerson           10-30 days      31-45 Days      45-60 Days       61 to MaxDays

XXX                     AAAA                      10000             2000                  5890                   3300000

ABVB                    ABC                           230             4500                  790                     5000000

is this possible............??

[ashfaq_haseeb]

You need to look at class() function.

Regards

ASHFAQ

[qv_testing]

Hi Ashfaq,

I made that bucket..

but i need input range

Suppose:

Start_Range      End_Range

10                         30

30                        45

50                        80

When i am click Generate Report button i want to generate report

Custmer            SalesPerson           10-30 days      30-45 Days      50-80 Days       81 to MaxDays

XXX                     AAAA                      10000             2000                  5890                   3300000

ABVB                    ABC                           230             4500                  790                     5000000

Hope you understand.................

[MarcoWedel]

please provide sample application

[qv_testing]

Hi Macro,

Please See this link Need Help??

PFA,

[#6]

Example.

Persona:

LOAD * INLINE [

    Customer, PersonalSales, Days

    Cust1, PersSale1, 10

    Cust1, PersSale1, 40

    Cust1, PersSale2, 100

    Cust1, PersSale2, 11

    Cust2, PersSale3, 58

    Cust2, PersSale1, 22

    Cust2, PersSale2, 16

    Cust2, PersSale2, 30

];

RangeDays:

LOAD * INLINE [

    Star_Days, End_Days, Desc_Days

    10, 30, 10-30 Days

    31, 45, 31-45 Days

    45, 60, 45-60 Days

    61, 100000, 61 to MaxDays

];

left join (RangeDays)

IntervalMatch (Days) LOAD Star_Days, End_Days Resident RangeDays;

atte.

Luis Valencia

[qv_testing]

Hi Luis,

But here, based on user input values.....

[#8]

es lo que buscas?.