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

[krishna20]

Hi Harsha,

I Displayed total value. It's not a problem . The main issue is I'm not able to create Bandwidth range as mentioned above for only <0 and Above 1,000,000. This is the main problem i'm facing .I'm  getting for one Band and not for another one don;t know the reason.

[#3]

you mean to say,

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

Dual('Above 1,000,000',7) are not working else working ...

& let me clear have u tried above bucket is working proper or not at your end...

[krishna20]

Hi,

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

Dual('Above 1,000,000',7) are not working.

No that bucket concept is not working.

[#5]

can u provide T_GI_CLM_SETL.qvd on my mailid harshal.patil457@gmail.com

finally try like below,

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

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,

[#6 · Accepted solution]

Hi krishna,

Finally your issue resolved.

In your case there is no data for CS_AMT_LC_1 hence your condition is not satisfy & in result only <0 range will come but not above 1000000 when data available it will show as fieldvalue in BandField..

I have attached document with Band_Claim1 as resulted field.

PFA,

Thanks & regards,

Harshal

[krishna20]

Hi Harsha,

Thank you very much for finding mistake...Absolutely fine your solution is.

Regards

Krishna