Skip to content

SearchKit/FormBuilder - handling monetary totals

A few related issues around totals of contributions:

  1. One frequent need is to show a list of Contributions with a total. SearchKit produces the list and FormBuilder happily adds up the contribution amounts regardless of currency, producing a useless figure.

For example with a simple search of contributions shown in a table with Totals enabled:

image

Probably the most user-friendly is to show a total like '$175.00, £25.00', maybe with an option for 'USD 175.00, GBP 25.00'

  1. If we try to get totals by adding 'group by currency' we get:

image

Note that the GBP figure has lost the '£' and now shows with the default currency symbol '$'

In this case, if there was no currency symbol we could use rewrite to add '[currency:name]' as a workaround, but the '$' interferes with that.

See also: #3428 (closed) and https://github.com/civicrm/civicrm-core/pull/24524

To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information