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.
fixed by change the action tool formula, instead formula in list box tools.
REGEX_Replace([#1], '(".+?")', '<SummarizeField field=$1 action="Sum" rename=$1 />')
additional: i tested in 2023.1 and 2024.2possible 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
Both show as "_sum" to me in your screenshots - feel free to post the macro for the most help
@alexnajm i thought i posted it already.
currently my solution is add another replace to cover the "_sum".
