BandWidth

[krishna20]

Hi Friends,

I'm Having a field as AMT_LC_1.

I need to set bandwidth for this amount by the limit range. I Have done as  below.But, it's not working properly. I mean When i select the particular bandwidth, The paid amount should be displayed according to the range value. Please find the attached image for clear Idea.

if(AMT_LC_1<0 ,Dual('<0',1),

if(AMT_LC_1>1 and AMT_LC_1<=500000,Dual('1-500,000',2),

if(AMT_LC_1>=500001 and AMT_LC_1<=1000000,Dual('500,001-1,000,000',3),

if(AMT_LC_1>=1000001 and AMT_LC_1<=2000000,Dual('1,000,001-2,000,000',4),

if(AMT_LC_1>=2000001 and AMT_LC_1<=5000000,Dual('2,000,001-5,000,000',5),

if(AMT_LC_1>=5000001 and AMT_LC_1<=10000000,Dual('5,000,001-10,000,000',6),

if(AMT_LC_1>10000000,Dual('Above 10,000,000',7)))))))) as  Band_width,

Please anyone suggest me.

Regards

Krishna

[#2]

Hi Krishna,

Are you sure your range <0 and Above 1,000,000 is not matching with CS_AMT_LC_1 cause for your both band results looks ok...!

[krishna20]

Hi,

In the Second range(Claim_Band) list box <0 and Above 1,000,000 is not displaying.That one is first issue.

[#4]

Put

CS_AMT_LC_1=<0

if you want to include 0 in range

[krishna20]

Hi Harsha,

Thank you.

Perfect !! Displaying <0 is working by using <=0 . I will be having negative values in Sum(CS_AMT_LC_1) .In that scenario it won't works right? Above 1,000,000 also I need to display in this list box.

[#6]

Negative values in Sum(CS_AMT_LC_1) will return -ve value take text-box & put =Sum(CS_AMT_LC_1) in it ..

Now you want 'above 1,000,000' then should use >1,000,000

But may be you are using 'Above 10,000,000' for Claim_Band please check & let me know

if it is then use >10,000,000 simple case...

[#7]

Hi,

you are using straight table select expression & find total mode under expression select sum under dropdown for total..

in your dashboard there is no any data present for event field hence the total will be 0

[krishna20]

Hi Harsha,

In the script i have used two bands .The above range is different from the below range. In the below range above 1,000,000 is not showing.

[krishna20]

Hi Harsha,

I'm using Expression total in total mode. Its displaying total sum. It shouldn't be zero, because values are there in CS_AMT_LC_1 field.

[krishna20]

Hi Harsha,

I found that in the second bandwidth range script (Sample app) for the Above 1,000,000 ,if i used <= 1,000,000 it's displaying in list box. The other options are not working.Why may cause this issue? Any idea?

[#11]

Promote Event field it will give total..

IF(CS_COMP_CODE='005' or CS_COMP_CODE='006',

(if(CS_AMT_LC_1<=1 ,Dual('<0',1),

if(CS_AMT_LC_1>1 and CS_AMT_LC_1<=50000,Dual('1-50,000',2),

if(CS_AMT_LC_1>=50001 and CS_AMT_LC_1<=100000,Dual('50,001-100,000',3),

if(CS_AMT_LC_1>=100001 and CS_AMT_LC_1<=200000,Dual('100,001-200,000',4),

if(CS_AMT_LC_1>=200001 and CS_AMT_LC_1<=500000,Dual('200,001-500,000',5),

if(CS_AMT_LC_1>=500001 and CS_AMT_LC_1<=1000000,Dual('500,001-1,000,000',6),Dual('Above 1,000,000',7))))))))) as  Band_Claim,

it will work