using and operator in if condition

[pooja821]

How do we use and operator in if condition.

for eg.

if we need to represent account between 1 million and 5 million, so do we do that?

[zhadrakas]

in Expression

=if(account >1000000 and account <5000000, THEN , ELSE)

in Script

if(account >1000000 and account <5000000, THEN , ELSE) as Field,

Regards

tim

[pooja821]

I need to use and in above condition for middle account along with aggregate and sum function.

[zhadrakas]

seems like you should use it like this:

aggr(sum(if(middle_account>1000000 and middle_account<5000000, middle_account)), YourDimension)

[pooja821]

=if(Aggr(sum(Revenue),[Customer Group Descr])<1,'Tail Account',

              if(Aggr(sum(Revenue),[Customer Group Descr])>1 and Aggr(sum(Revenue),[Customer Group Descr])<5,'Middle Account',

                  if(Aggr(sum(Revenue),[Customer Group Descr])>=5,'Large Account'))

I m getting error in this expression

what is wrong with it?

[zhadrakas]

do you really Need the aggr() function at this Point?

if you have Customer Group Descr as Dimension you can use this expression:

if(sum(Revenue) < 1,'Tail Account',

              if(sum(Revenue)>1 and sum(Revenue) <5,'Middle Account',

                  if(sum(Revenue)>=5,'Large Account')))

[pooja821]

Yes, as I need to group by customer group descry.

[pooja821]

This AND is not working fine.

I m getting invalid dimension error.

[zhadrakas]

can you share a sample qvw?