How to get rid of decimal places with #Landscape Area#.#area# on a data tag

[twaikin 3]

Hi all. I am still having trouble with decimal places on the data tag, especially with #Landscape Area#.#area# and plant quantity.

 

The problem: Too many decimal places on a data tag. I want to get rid of all decimal places. Pretty obvious this is not governed by the overall units setting.

 

I followed the solution in another thread (See below) to remove decimal places for plant quantity. But similar approach didn't work for #Landscape Area#.#area#. No matter which Number Format I choose, the decimal places remain on the data tag.

 

Any idea?

 

 

[Pat Stanford 1,660]

I believe you have to add the formatting into the data tag itself.

 

Either Edit the Tag Style or if you only want to change it for a single tag convert it to Unstyled and then edit the tag.

 

Bottom of the OIP click the Edit Tag Layout button.

Select the text block that represents the field you want to change the formatting for.

Botton of the OIP click the Define Tag Field button

In the dialog box that opens

    delete the "formula" that is currently in the Current Tag Definition Field

    set the units to something other than Document Preferences

    set the Precision to the number of decimal places you want.

CLICK THE ADD TO DEFINITION BUTTON (Yes, I am yelling because about 90% of the time I forget this step and have to do the whole thing again). ;-)

Click OK

Click Exit Tag Layout Edit

 

Once you figure out how it works, you can actually just type for format you need into the Current Tag Definition field.

 

HTH

[ljack 1]

You were so close!

Do the same steps you were doing in the 'Record Format Connection', but edit 'Plant Record' instead of 'Landscape Area'.

Edit the 'Quantity' definition from 'Decimal' to 'General'.

 

 

[Mark Aceto 455]

I’m trying to do the same thing with Area and Function in the Space Tool Label (not a data tag):

 

 

For Area, I would like to add a separator.

 

For the function (Mac Occupancy), I would like to remove decimals.

 

However, I can’t seem to edit the Record Format Connection. Text, Number, and Integer seem hardwired in there… 

 

[Pat Stanford 1,660]

I believe that one of the reasons the  Data Tag object was created was that the individual object tags (like the Space label) were not flexible enough to allow you to change the units. You may be out of luck.  :-(

 

[Mark Aceto 455]

@Pat Stanford if I can figure out how to get rid of the “sq ft” in the Max Occupancy, I’ll happily switch over to the Data Tag:

 

[Mark Aceto 455]

OK, I’m sure it’s only a matter of time before this bites me in the arse but here’s a workaround:

 

1. Change document units for Area > Unit Mark to a [space] (highlighted in light blue below):

 

 

2. Add “sq ft” (or ft² or whatever you want) to the end of the Data Tag formula for:

• Gross Area
• Net Area
• Load Factor

 

That solves everything except the thousands separator which I believe is a much deeper rooted issue:

 

[Mark Aceto 455]

Nope; spoke too soon… 

 

I had manually entered the load factor in the data tag:

 

 

But when I switch it back to the formula pulling the load factor value from the OIP:

 

 

I get this output, so I’m right back where I started:

 

Edited December 23, 2020 by Mark Aceto

[Mark Aceto 455]

Is there a way that I can enter a ROUND function in the Data Tag formula?