metadata-calculate on calculated value

[NielsJ]

I am trying to sum a summed value with the metadata-calculate macro and getting strange results. This is my setup:

Page 1-1
Label: level_1
Wiki: {metadata:mctest}5{metadata}
Result: 5

Page 1-2
Label: level_1
Wiki: {metadata:mctest}3{metadata}
Result: 3

Page 2-1
Label: level_2
Wiki: {metadata:mctest}{metadata-calculate:mctest|label=level_1}{metadata}
Result: 8 (=5+3)

Page 2-2
Label: level_2
Wiki: {metadata:mctest}12{metadata}
Result: 12

Page 3
Wiki: {metadata-calculate:mctest|label=level_2}
Result: 11 (I was expecting 20...)

Has anyone tried this before or can say why it isn't working?

[NielsJ · Accepted solution]

I debugged into the Metadata plugin and found that this is not possible. Internally the nested macro is not executed, so the String "{metadata-calculate:mctest|label=level_1}" is converted to a number omitting all non-number, point and minus signs. So we get -1 for this value and 11 as result.

[AlexeyM]

And for any calculations you may use CelesteCS Math for Confluence. Please contact me directly on any question on this plugin.

Thanks!