Bug? Macro for Summarize tool: the prefix "Sum_" become suffix "_Sum"

[PangHC]

i just create a macro for subtotal and grand total, but the column name have different behavior.

where the "sum_" become "_sum"

when i debug, it working again if i click into the conflguration. 

[PangHC]

additional: i tested in 2023.1 and 2024.2

possible reason is rename missing so add "action" and "field" to form "rename"

and the "action" are in front of "field" and cause the concate error.

but the input value is "action" are behind the "field"

here the normal for comparison

[alexnajm]

Both show as "_sum" to me in your screenshots - feel free to post the macro for the most help

[PangHC]

@alexnajm 
i thought i posted it already.

currently my solution is add another replace to cover the "_sum".

[PangHC · Accepted solution]

fixed by change the action tool formula, instead formula in list box tools.

REGEX_Replace([#1], '(".+?")', '<SummarizeField field=$1 action="Sum" rename=$1 />')