Skip to first unread message

Andy D.

Jan 31, 2023, 1:16:53 PMJan 31
to mementodatabase
So I just discovered aggregation.
Trying it out in this library and the total comes to $5,342.76
But it writes it as 5 342.76
How can I get Memento to either not put that space in or to put a comma there?agg.PNG

Bill Crews

Jan 31, 2023, 1:31:49 PMJan 31
to Andy D., mementodatabase
I think there is no setting for that, so you may have to live with it.

Number fields (like Integer, Real, & Currency) have a Thousands separator Advanced parameter. It's by default Off for Integers & Reals, but for Currency fields, it is On by default. So, if it's On for the fields, it's probably On for the aggregation as well, so just turn it off, and that should work for both.

I don't know how to get commas (periods in Europe). I think it's either a space or nothing.

You received this message because you are subscribed to the Google Groups "mementodatabase" group.
To unsubscribe from this group and stop receiving emails from it, send an email to
To view this discussion on the web visit
Reply all
Reply to author
0 new messages