topic Re: If with and statements not working in Connectivity & Data Prep

If with and statements not working

sgrewal — Tue, 22 Nov 2022 20:37:09 GMT

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)

Re: If with and statements not working

Frank_S — Tue, 22 Nov 2022 22:53:54 GMT

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

Re: If with and statements not working

sgrewal — Wed, 23 Nov 2022 14:24:30 GMT

Looks like that does not work.

It is showing a right parentheses error.

But all are present.

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

Re: If with and statements not working

sgrewal — Wed, 23 Nov 2022 14:25:14 GMT

The image did not upload so here it is

Re: If with and statements not working

Or — Wed, 23 Nov 2022 14:39:18 GMT

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)