9 Replies Latest reply: Oct 29, 2014 12:11 PM by Felim Shanaghy

# Fulfill condition

Hi All

I have one conditional diagram as below

If(Zip=11378, 'New York',

if(Zip=11377, 'New York',

if(Match(Zip, 11377,11378), 'Queens')))

The third condition for 'Queens' not filfilled out because above two condition. How do I please?

Thanking you all

• ###### Re: Fulfill condition

What kind of descriprion you want when zip = 11378 or 11377 New York or Queens?

Or Queens has precedence on New york?

Let me know

• ###### Re: Fulfill condition

Hi Alessandro

Basically Queens is suburb of New York. Zip 11377 and 11378 belong to Queens.

Same way Bronx is also suburb of New York and having Zip let say 12377, 123788

As Queens & Bronx are Suburb of New York so I want both in one chart and one column

Thanks for

• ###### Re: Fulfill condition

Ok but with a unique number you cannot have more description so the best to do is:

If(Zip = 11377  or Zip = 11378,  'Queens - New York',

If(Zip = 12377  or Zip = 12378,  'Bronx - New York',

,'Other'

)

)

• ###### Re: Fulfill condition

As you mentioned Queens, Bronx is a Suburb of New York(which is a City), therefore move New york to a different table/field. think of it as adress1, adress2, POST CODE, town, city, prov, state etc.. unless there is a suburb called New York, which makes New York, New York city. how about that?

• ###### Re: Fulfill condition

The third condition will never be fulfilled as it will always be satisfied by one of the two prior

• ###### Re: Fulfill condition

Hi Felim

I agree for this but any other way?

Thanks

• ###### Re: Fulfill condition

If I simplyfy

If I have data like

Zip      Suburb   Population

11377  Queens  100K
11378  Queens  110K

Req is

11377              100K

11378              110K

11377 or 11378 220K

No groups here simply chart

• ###### Re: Fulfill condition

you could concatenate

• ###### Re: Fulfill condition

To be honest you could order by suburb and use the peek function to see if the previous row has changed and calculate it like that or create a summary table and use a group by?