Title: Multiply two fields
Last modified: January 12, 2017

---

# Multiply two fields

 *  [andytruetone](https://wordpress.org/support/users/andytruetone/)
 * (@andytruetone)
 * [9 years, 4 months ago](https://wordpress.org/support/topic/multiply-two-fields/)
 * What’s the correct transform syntax to create a column that multiplies two fields
   for each Contact Form 7 entry sent to the database? For example Units * UnitCost
   = TotalCost.
 * It seems so simple but I can’t seem to find the right way to do it.

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

 *  Thread Starter [andytruetone](https://wordpress.org/support/users/andytruetone/)
 * (@andytruetone)
 * [9 years, 4 months ago](https://wordpress.org/support/topic/multiply-two-fields/#post-8647878)
 * Update: I found the answer…
 * `trans="total=multiply(units,unitCost)"`
 * But I have another question. How do I make a summary table with the total of 
   this calculation and the sum of another field? I thought this would be it but
   it didn’t work.
 * `trans="total=multiply(units,unitCost)&&SumField(total,customer)&&SumField(units,
   customer)"`
 *  Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * (@msimpson)
 * [9 years, 4 months ago](https://wordpress.org/support/topic/multiply-two-fields/#post-8649139)
 * Try SummationRow
    [https://cfdbplugin.com/?page_id=1167](https://cfdbplugin.com/?page_id=1167)

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

The topic ‘Multiply two fields’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/contact-form-7-to-database-extension_ffffff.
   svg)
 * [Contact Form DB](https://wordpress.org/plugins/contact-form-7-to-database-extension/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/contact-form-7-to-database-extension/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/)
 * [Active Topics](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * Last activity: [9 years, 4 months ago](https://wordpress.org/support/topic/multiply-two-fields/#post-8649139)
 * Status: not resolved