FP sum of values in attributes: value generated with formulas and manually, use of icons

[Illegit]

Hi, I have a map where I need to sum the attribute values called "upd". It is a % of advancement.

Sum of UPD attribute.zip
I use icons: 1) the green tick to attribute te value 1 to upd and 2) the Zzz icon to tell to the formula not to account in upd that node.

Now the question I cannot answer: my formula works well always except when it is accounting a node with the same formula inside the upd value generating an error: which is the mistake? How to correct this formula?

you can play with the above map to test your solutions.
Thanks in any case for the attention.

[Illegit]

I tried a different formula, but I got the same problem as above: see the zip file
sum of attr values w icons.zip
the formula:
if (children.size()<1){res=0}else{num=children.collect {if(!it.icons.contains("MarkdownHelper/completed")&!it.icons.contains("Notes/zzz")){it.attributes.findAll(){it.key=='upd'}.value}else if(it.icons.contains("MarkdownHelper/completed")&!it.icons.contains("Notes/zzz")){1}else{0}}.flatten().sum(0); den=node.children.count{!it.icons.contains("Notes/zzz")}; res=num/den}; format(res,'#.00')

this formula fails when summing up nodes with the same formula inside their upd attribute value
what is wrong?
how to correct it?
Thanks for feedback.

[macmarrum]

In the following code, .value gets you the raw value of the attribute, which in your case is the formula's text.

            def updAttribute = child.attributes.find { it.key == 'upd' }
            return updAttribute ? updAttribute.value : 0

To get the result of the formula evaluation, you can use either .getTransformed() or .findValues

            def updAttribute = child.attributes.transformed.find { it.key == 'upd' }
            return updAttribute ? updAttribute.value : 0

.findVlaues will return a list of Convertible

            def updAttributeList = child.attributes.findValues { key, value -> key == 'upd' }
            return updAttributeList ? updAttributeList[0].num : 0

The above can be simplified. NodeRO returns an attribute's value as Convertible when square brackets are used => node['upd'].
Then you can use .num0 on the Convertible to get it as a number; if not-a-number (e.g. null), it will return 0

            return child['upd'].num0

[Illegit]

Thank you macmarrum, it works finely.