How to Sum User Text Attribute Values?

[Pipouille]

Hi,

I’m trying to sum the values from a User Text attribute across multiple objects — for example, to get the total of the “Area” values.

AttributeUserTextSum.3dm (3.8 MB)

Is there a way to do this?
Any help would be appreciated!

Thanks in advance.
Best,
Pip

[martinsiegrist]

I looked at this post

Calculation does not work with decimal

Yes you can. This is what your %<748+float(UserText(“block”,“Local_height”))>% would need to look like to format to two decimal places: %<'{:#.2f}'.format(748+float(UserText(“block”,“Local_height”)))>% For a different number of decimals just change the 2 to whatever you want. What we are doing here is using Python formatting commands to display a string with a placeholder - the curly brackets - in it which will be filled with the result of the calculation in the brackets after the format inst…

Unfortunately I could not get it to work.

[wim (Wim Dekeyser)]

Hi Pip -

@Pipouille

I’m trying to sum the values from a User Text attribute across multiple objects — for example, to get the total of the “Area” values.

Sum: %<Area(“GUID”) +Area(“GUID”)>%

-wim

[Pipouille]

Hi Martin and Wim,

Thanks for your help.

As Martin understood, I was more interested in executing operations on UserText directly rather than calling functions.

But It seems that applying an operation to a function like Area via UserText doesn’t work.
As Wim suggested, the function needs to be called directly.

For other types of UserText, however, Martin’s approach seems to work!

[martinsiegrist]

@Pipouille

But It seems that applying an operation to a function like Area via UserText doesn’t work.

@wim what’s keeping the addition of attribute user text from working?

I tried a few things. Addition of numbers works but I guess the attribute user text isn’t parsed correctly. What’s wrong with this:

%<float(str(UserText("b37e804a-2c26-4717-abef-ea03564b9450","Area")))>%

AttributeUserTextSum_mrtn.3dm (66.9 KB)