Click here to see the original blog: Parcel Area – Commas
Just to clarify, the trick involves six expressions:
- HundredsSize: IF({Parcel Area}>1000,0.0000000000000001,0.1/12)
- Hundreds: ({Parcel Area}/1000000-TRUNC({Parcel Area}/1000000))*1000
- ThousandsSize: IF({Parcel Area}>1000, IF({Parcel Area}<1000000,0.1/12,0.0000000000000001),0.0000000000000001)
- Thousands: {Parcel Area}/1000000
- MillionsSize: IF({Parcel Area}>1000000,0.1/12,0.0000000000000001)
- Millions: {Parcel Area}/1000000000
The label involves 4 text components: Parcel Name, Hundreds, Thousands, Millions
- Parcel Name is the parcel name.
- Hundreds is the area label configured for when parcel area is less than 1000.
- Thousands is the area label configured for when parcel area is more than 1000 and les than 1,000,000.
- Millions is the area label configured for when parcel area is more than 1,000,000.
The latter three components size themselves down to nothing as per the "Size" expressions listed above depending upon how their conditions check. In this example, labels will go in at 0.1" i.e. 0.1/12 as the expression reads. If you label using a smaller height like at 0.08", change each "Size" expression to use 0.08/12.
Think this is brilliant? Thank Christopher Fugitt who posted it at 12:31 AM this morning!
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.