Custom Data Tag with dynamic field(wattage to current)

[Juay]

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?

[Nikolay Zhelyazkov]

Hello @Juay,

 

Maybe this will get the job done?  #WS_ROUNDUP('Power Requirement'.'Wattage'/230,0)#

 

Best Regards,

Nikolay Zhelyazkov

[Juay]

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?

[Nikolay Zhelyazkov]

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.

[Juay]

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

😁