How to transclude outputs of macro in a field?

HelIo and Happy New Year!

I am using Dynamic Field to create a table that gives me the sum value of money spending on different categories of things.

For example if I need to display food cost of 2020 I would create a field called “FoodSpending2020” with the following:

{{{ [regexp[.2020.] get[FoodSpending2020]] +[sum[]] }}}

Now I need to put the above value into the table

<<ColumnTable “[enlist[Summary]]” “FoodCost”>>

The output of the table cells looks like below:

Is there anyway to display the output?

I don’t know whether this (quite old by now) macro solution can be modified so that columns display not just the text from a field, but the calculated output of a filter… And I suspect that Jed Carty is not hanging out here on this forum these days (certainly not by that name).

I do know that Shiraz dynamic tables — a current and feature-rich variation on that theme by @Mohammad — can work with column templates. You can tell it that all the cells under the Summary column header should display a certain way…

2 Likes