What I’m trying to do
This seems simple but I couldn’t find anything on how to do it. How do I display the total_amount number in my table with comma separators?
TABLE round(sum(rows.amount),2) as Total_amount
FROM "/Area"
group by date
This seems simple but I couldn’t find anything on how to do it. How do I display the total_amount number in my table with comma separators?
TABLE round(sum(rows.amount),2) as Total_amount
FROM "/Area"
group by date
Do you mean to present a number like 1234567.12 as 1,234,567.12?
I don’t think there is any support for presenting number like that currently.
This post mentions it, but just as a question.
A quick search indicates you can hack a solution using regex, so maybe something like the following would work in your case:
```dataview
TABLE regexreplace(round(sum(rows.amount), 2), "\B(?=(\d{3})+(?!\d))", ",")
as "Total amount"
FROM "/Area"
GROUP BY date
```
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.