Bandwidth Inline

[krishna20]

Hi friends,

Below is my expression.I want to load this expression in Load or Inline Table.

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

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

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

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

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

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

if(AMOUNT>10000000,Dual('Above 10,000,000',7))))))))

Please find the below attachments.

Error_band Image shows what I'm getting and Correct_Band shows what i need.Please anyone can help me out.

Regards

Krishna

[ashfaq_haseeb]

Hi,

This could mean that you don't have values for AMOUNT less then 0.

Regards

ASHFAQ

[krishna20]

Hi Ali,

I Need to show this expression as a field.I'm having values below zero.The above Error_band Image (Expression) i implemented in Editor Script and  Correct_Band (Expression) implemented in List Box Expression.

Regards

Krishna

[ashfaq_haseeb · Accepted solution]

It will not work with inline take this code to proper table.

Regards

ASHFAQ

[its_anandrjs]

Hi,

In any resident load this is possible

Load

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

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

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

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

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

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

if(AMOUNT>10000000,Dual('Above 10,000,000',7)))))))) as NewField

Resident TableName;

But inline is not possible.

Regards

Anand