Juay Posted April 14, 2022 Share Posted April 14, 2022 Hi guys, I was trying to use a custom record format field(wattage) and do a simple math operation to get the current to appear in a data tag. #Power Requirement#.#Wattage#/230 This works and i end up with lots of decimal space. I am able to get #WS_ROUNDUP(numerical_value,0) working if i put a number. Anyone can point me how to put the math operation in? Quote Link to comment
Vectorworks, Inc Employee Nikolay Zhelyazkov Posted April 14, 2022 Vectorworks, Inc Employee Share Posted April 14, 2022 Hello @Juay, Maybe this will get the job done? #WS_ROUNDUP('Power Requirement'.'Wattage'/230,0)# Best Regards, Nikolay Zhelyazkov Quote Link to comment
Juay Posted April 14, 2022 Author Share Posted April 14, 2022 Hi Nikolay, Thank you so much. It does work! I notice that it is 'Power Requirement'.'Wattage' instead of #Power Requirement#.#Wattage#. May I know whats the rule for this syntax? Quote Link to comment
Vectorworks, Inc Employee Nikolay Zhelyazkov Posted April 14, 2022 Vectorworks, Inc Employee Share Posted April 14, 2022 Just now, Juay said: I notice that it is 'Power Requirement'.'Wattage' instead of #Power Requirement#.#Wattage#. May I know whats the rule for this syntax? - Yes. The data tag syntax is the one with the #. However, everything inside #WS_<here># is using the worksheet syntax. So what you put in there should work exactly the same if you put it in a database worksheet. 2 Quote Link to comment
Juay Posted April 15, 2022 Author Share Posted April 15, 2022 11 hours ago, Nikolay Zhelyazkov said: - Yes. The data tag syntax is the one with the #. However, everything inside #WS_<here># is using the worksheet syntax. So what you put in there should work exactly the same if you put it in a database worksheet. Hi Nikolay, Thanks for the help and explanation 😁 Quote Link to comment
Recommended Posts
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.