Query table function sum not working

i have a block template to calculate tea expense.
-[[tea and snacks expense]]
amount::
expense-category::

I normally create blocks with this template in the journals page daily.

when I query with
{{query(and [[tea and snacks expense]] (between [[Mar 26th, 2023]] [[Apr 25th, 2023]] ))}}
it returns query table

and I use a query table function below it as a child block to the above query
{{function (sum :amount)}}
logseq does not return the total amount. what could be the reason?

It was working before, but now its not working.

1 Like

Hi there,

I suggest hopping on this bug report in GitHub. Query table function `sum()` not work · Issue #9173 · logseq/logseq · GitHub