To Build Logic

[abhaysingh]

Hello every one i want to show below analysis.

AvgSale/Month	Total Dealer	Product Sales(Avg/Month)	Total Outstanding
<=10K
>10K && <=30K
>30K && <= 80K
>80K && <=150K
>150K && <= 200K
200K && <=300K
>300K && <=375K
>375K && <=500K
>500K && <=750K
>750K && <=1000K
>1000K

I am able to make the buckets on the basis of sales but facing issue to show overall analysis.

Please help technically to build this.

[#2]

Please post some data

Thanks,

Sri

[abhaysingh]

what you required exactly so i can post it in better way

[ashfaq_haseeb]

Hi,

use class() function.

Regards

ASHFAQ

[avinashelite]

Hi Abhay,

Create interval for those values like below eg.

Interval_Table:

    LOAD * Inline

    [

    Low,High,Group

0,10,0-10 Score

10.01,20,10-20 Score

20.01,50,20 - 50 Score

50.01,70,50 - 70 Score

70.01,100,70 - 100 Score

];

Result:

IntervalMatch ( [Acquired Grade])

LOAD Low, High

Resident

Interval_Table;

[abhaysingh]

hi avinash

could u pls elaborate me more like,

what is low and high values??

acquired grade???

[avinashelite]

Hi Abhay,

This an example I am showing below.

In order to get the values between a range for eg between 0to100, 100 to 500 etc  you need to create a interval for it like 0-100 one interval and 100-500 one interval. This is what i am trying to do.

Here Low and High are the range value, to take your scenario

0-10,000 is a interval so first define the that inerval low(0) and High(10,000) end so that you will get all the values within this range.

Acquired Grade is an eg field for which you want to create the interval.  In your case may be Total Outstanding.

Interval_Table:

    LOAD * Inline

    [

    Low,High,Group

0,10,0-10 Score

10.01,20,10-20 Score

20.01,50,20 - 50 Score

50.01,70,50 - 70 Score

70.01,100,70 - 100 Score

];

Result:

IntervalMatch ( [Acquired Grade])

LOAD Low, High

Resident

Interval_Table;