Title: Using [pdb_total]
Last modified: July 24, 2019

---

# Using [pdb_total]

 *  [DavidK](https://wordpress.org/support/users/davidk/)
 * (@davidk)
 * [6 years, 10 months ago](https://wordpress.org/support/topic/using-pdb_total/)
 * Hi –
    I’m not a developer. I can’t write CSS or PHP, but I can following instructions.
 * I hope a very simple problem.
 * I need a sample on how to use the short code [pdb_total] to total or sum a currency
   field from all the records in a database. …. 300 records, some people have paid
   and some haven’t. The amount paid is in the currency field. How do I modify this
   short code for a field called: paid_already_2019 …

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Plugin Author [xnau webdesign](https://wordpress.org/support/users/xnau/)
 * (@xnau)
 * [6 years, 10 months ago](https://wordpress.org/support/topic/using-pdb_total/#post-11764191)
 * The way this works ([which is explained here](https://xnau.com/work/wordpress-plugins/participants-database/using-the-participants-database-plugin/#total))
   is that if you include a “fields” parameter in the shortcode, it will try to 
   show a total (the data must be numeric) of the values in those fields. So, for
   your example, you could use a shortcode like this:
 * `[pdb_total fields="pledged_2019"]`
 *  Thread Starter [DavidK](https://wordpress.org/support/users/davidk/)
 * (@davidk)
 * [6 years, 10 months ago](https://wordpress.org/support/topic/using-pdb_total/#post-11764295)
 * THANK YOU. Call me stupid — but this works and the whole plugin is BRILLIANT.!!!
   
   Thanks. Curious — Is there a parameter [pdb_total fields=”pledged_2019″] that
   would return the number exceeding 999 with a comma; like instead of 3523, it 
   would show 3,523 … or even better: $3,523 ….
 * I guess someday, maybe I need to learn write CSS.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Using [pdb_total]’ is closed to new replies.

 * ![](https://ps.w.org/participants-database/assets/icon-256x256.jpg?rev=1389807)
 * [Participants Database](https://wordpress.org/plugins/participants-database/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/participants-database/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/participants-database/)
 * [Active Topics](https://wordpress.org/support/plugin/participants-database/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/participants-database/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/participants-database/reviews/)

## Tags

 * [adding](https://wordpress.org/support/topic-tag/adding/)
 * [sum](https://wordpress.org/support/topic-tag/sum/)

 * 2 replies
 * 2 participants
 * Last reply from: [DavidK](https://wordpress.org/support/users/davidk/)
 * Last activity: [6 years, 10 months ago](https://wordpress.org/support/topic/using-pdb_total/#post-11764295)
 * Status: not resolved