Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for
Did you mean:
Specialist II

## Bandwidth Inline

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))))))))

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

Regards

Krishna

1 Solution

Accepted Solutions
Champion III

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

Regards

ASHFAQ

4 Replies
Champion III

Hi,

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

Regards

ASHFAQ

Specialist II
Author

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

Champion III

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

Regards

ASHFAQ

MVP

Hi,

In any resident load this is possible

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

Community Browser