|
How can i create a list in the Formulas area?
For instance.
If ZIP codes are [35452,24785,95742,74565] Then "Chambers" County
else if [45844,58745,35471] then "asdf County" ETC.
How do I write that?
I have about 50 zip codes that I am going to compress together by county and list the County on a Group Header to group all the zips for that one county all the way down.
|
|
HI
Your question is having the answer, only thing is need to use correct syntax:
If {zipcodefile} in ['35452','24785','95742','74565'] Then "Chambers"
Else
If {zipcodefile} in ['45844','58745','35471'] Then 'ASDF'
Else
If .. so on..
Since zip code filed always be in string data type you need to put them in single /double cots.
Insert group on above formula to group all related countries.
Edited by Sastry - 10 Aug 2019 at 12:18am
|
IP Logged
