If with and statements not working

[sgrewal]

Hi, 

I am trying to create a calculated field and it only works if there is one criteria and I can not use and or as the condition expression. 

I also tried putting parantheses like this (saw it mentioned in a different post) :if(([Count]>26 and [Count ]<51),1,0)

[Frank_S]

Try it this way...
=If(Count(OrderID) >=1 and Count(OrderID) <=3, 1,0)

In your case

=If(Count(Your_dimension) >=26 and Count(Your_dimension) <=51, 1,0)

Or if you have a space in your dimension name, use:

=If(Count([OrderID]) >=26 and Count([OrderID]) <=51, 1,0)

Kind regards...

[sgrewal]

Looks like that does not work.

It is showing a right parentheses error.

But all are present.

[cid:image001.png@01D8FF1D.54B4A910]

[sgrewal]

The image did not upload so here it is

[Or · Accepted solution]

Data Manager does not allow the use of AND / OR. Either switch to using the Data Load Editor, or write your statements as nested if(), e.g. If(POQTY >=1, if(POQTE <=3,1,0),0)