Jump to content

Data tags and mathematical operations?


JMR

Recommended Posts

Ok thanks, now it's working!

 

image.thumb.png.983bd1c545fe4aceaf30523350f555ff.png

 

Is there a way to round the calculation down to the closest integer? That way I could calculate the loss percentage as well.

 

Eg. the second row from the bottom is as follows currently:

Divs in L #datataghelper#.#FullLength# / #ΔX##m_1_0#

 

The meter and .1 accuracy is to get rid of too many decimals.

 

 

data tag sample.vwx

Link to comment
  • 10 months later...

Hey folks - I'm not getting anywhere trying to find the 2022 docs for this so here's the question:

Can I use the Roundup function within a data tag?

 

=Roundup(#AREA##sq ft_1_0#/150*0.67,1)

 

is what I'm trying to do, and it just shows that text in the tag. The math works without the Roundup call.

thanks

Link to comment
  • Vectorworks, Inc Employee
On 12/10/2021 at 7:47 PM, techdef said:

Hey folks - I'm not getting anywhere trying to find the 2022 docs for this so here's the question:

Can I use the Roundup function within a data tag?

 

=Roundup(#AREA##sq ft_1_0#/150*0.67,1)

 

is what I'm trying to do, and it just shows that text in the tag. The math works without the Roundup call.

thanks

- Hello @techdef,

 

You can use the worksheet functions in the data tag as of VW 2022 but you cannot mix them that much to get what you are wanting here. What is possible atm is to have "#WS_ROUNDUP(AREA, 1)#" which will return rounded up area in document units, but you cannot add the unit overriding here.

 

Anyway, if you want to get the area in some different units than the document units and you want customized precision, just select Object Function Area, then select the desired units and precision and this should get the job done for you without the need to use roundup:

 

image.png

 

Best Regards,

Nikolay Zhelyazkov

Link to comment
  • 1 month later...

Hi,

 

greetings and very interesting thread.

 

Is this data tag possible (i struggle with it).

 

IF((#OSTYLE#='Raum Neu'), SUM#Space#.#Area#, 0)

 

If Objectstyle on active Layer = 'Raum Neu' sum 'Space'.'Area' otherwise show '0'

Objectstyle 'Raum Neu' = only space objects

 

Is it possible to sum in data tags or sum if?

 

/ / / 

 

I got the summed Space Area in a worksheet field.

Can i set a link in data tag to this specific worksheet field? 

how is the data tag formula for linking to workheets?

 

 

Greetings from Germany

Tobi

Edited by Tobias Kern
Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...