Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Read them logically
The third condition will never be fulfilled as it will always be satisfied by one of the two prior
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
Hi Felim
I agree for this but any other way?
Thanks
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
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'
)
)
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?
you could concatenate
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?