Title: Hide Default Zero Values in Calculated Field
Last modified: November 20, 2020

---

# Hide Default Zero Values in Calculated Field

 *  Resolved [CParris](https://wordpress.org/support/users/cparris/)
 * (@cparris)
 * [5 years, 7 months ago](https://wordpress.org/support/topic/hide-default-zero-values-in-calculated-field/)
 * Hello,
 * I have a form that generates a part number. The number is composed of several
   selections by concatenating them together in a single calculation field. Default
   values of the selection fields are currently left blank. However, before any 
   selections are made the calculation field result displays as a series of 0s. 
   I’d like the form to load with the Part Number Field blank, then gradually fill
   in the part number as selections are made. Is there a character(s) I can put 
   in the default value of each selection field that will show nothing rather than
   a zero? If not, is there a function that will suffice?
 * Thank you! This form plugin has the best logic I’ve seen and the support here
   is exceptional!
    -  This topic was modified 5 years, 7 months ago by [CParris](https://wordpress.org/support/users/cparris/).

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

 *  Plugin Author [codepeople](https://wordpress.org/support/users/codepeople/)
 * (@codepeople)
 * [5 years, 7 months ago](https://wordpress.org/support/topic/hide-default-zero-values-in-calculated-field/#post-13685548)
 * Hello [@cparris](https://wordpress.org/support/users/cparris/)
 * If you want to get the raw values of fields instead of their pre-processed values(
   the plugin tries to pre-process the fields’ values for the mathematical operations)
   use the fields’ names with the `|r` modifier in the equation, like: `fieldname1
   |r`
 * Best regards.
 *  Thread Starter [CParris](https://wordpress.org/support/users/cparris/)
 * (@cparris)
 * [5 years, 7 months ago](https://wordpress.org/support/topic/hide-default-zero-values-in-calculated-field/#post-13685635)
 * Hi Codepeople,
 * Yes, I saw another post of yours previously. So I already have the modifier assigned
   in the calculated Field like this:
 * `CONCATENATE(fieldname3|r, fieldname4|r, ...` . However the output of this shows
   as a bunch of zeros (one for each field). Like this: 00000000. How would I get
   these to start out blank instead?
 *  Plugin Author [codepeople](https://wordpress.org/support/users/codepeople/)
 * (@codepeople)
 * [5 years, 7 months ago](https://wordpress.org/support/topic/hide-default-zero-values-in-calculated-field/#post-13685641)
 * Hello [@cparris](https://wordpress.org/support/users/cparris/)
 * You can implement the equation as follows:
 *     ```
       CONCATENATE(IF(fieldname3, fieldname3, ''), IF(fieldname4, fieldname4, ''), IF(fieldname5, fieldname5, ''), IF(fieldname6, fieldname6, ''), IF(fieldname7, fieldname7, ''))
       ```
   
 * Best regards.
 *  Thread Starter [CParris](https://wordpress.org/support/users/cparris/)
 * (@cparris)
 * [5 years, 7 months ago](https://wordpress.org/support/topic/hide-default-zero-values-in-calculated-field/#post-13685645)
 * Wow, crazy how fast your reply was. Thank you! I will give this a try.
 *  Thread Starter [CParris](https://wordpress.org/support/users/cparris/)
 * (@cparris)
 * [5 years, 7 months ago](https://wordpress.org/support/topic/hide-default-zero-values-in-calculated-field/#post-13685710)
 * Yep, works perfectly! May I ask: Where would I find the documentation on this
   IF statement/function? You show 3 arguments and I’m not fully understanding how
   the logic works or what each argument represents.
    -  This reply was modified 5 years, 7 months ago by [CParris](https://wordpress.org/support/users/cparris/).
 *  Plugin Author [codepeople](https://wordpress.org/support/users/codepeople/)
 * (@codepeople)
 * [5 years, 7 months ago](https://wordpress.org/support/topic/hide-default-zero-values-in-calculated-field/#post-13685713)
 * Hello [@cparris](https://wordpress.org/support/users/cparris/)
 * The operation is described in the following link:
 * [https://cff.dwbooster.com/documentation#conditions-module](https://cff.dwbooster.com/documentation#conditions-module)
 * The operation structure is:
 * IF(condition, the result if the condition is true, the result if the condition
   is false)
 * Best regards.

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

The topic ‘Hide Default Zero Values in Calculated Field’ is closed to new replies.

 * ![](https://ps.w.org/calculated-fields-form/assets/icon-256x256.jpg?rev=1734377)
 * [Calculated Fields Form - AI Form Builder for WordPress - Contact, Payment, Quote, Quiz & More](https://wordpress.org/plugins/calculated-fields-form/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/calculated-fields-form/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/calculated-fields-form/)
 * [Active Topics](https://wordpress.org/support/plugin/calculated-fields-form/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/calculated-fields-form/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/calculated-fields-form/reviews/)

 * 6 replies
 * 2 participants
 * Last reply from: [codepeople](https://wordpress.org/support/users/codepeople/)
 * Last activity: [5 years, 7 months ago](https://wordpress.org/support/topic/hide-default-zero-values-in-calculated-field/#post-13685713)
 * Status: resolved