Help

Discover what data silos are costing your org in our commissioned Forrester study. Learn more

How to avoid the display of null numbers?

Topic Labels: Formulas
Solved
Jump to Solution
423 5
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi, can I get a blank space/nothing instead of “0” as the result of a formula ?
Capture d’écran 2022-01-24 à 14.26.43

1 Solution

Accepted Solutions

You can add some IF() to your formula to check the fields that are generating the zeros. Let’s say you have a Quantity value and if it is 0 the total will be 0. So:

IF(Quantity, Quantity * Price)

If there is not Quantity the Formula field value will be empty.

See Solution in Thread

5 Replies 5

You can add some IF() to your formula to check the fields that are generating the zeros. Let’s say you have a Quantity value and if it is 0 the total will be 0. So:

IF(Quantity, Quantity * Price)

If there is not Quantity the Formula field value will be empty.

Thanks a lot Elias !

It worked fine for all my fields… except one of them, I don’t understand why.
It’s a simple copy-paste, I retried several times, still get an error.
Formula too long ?

Capture d’écran 2022-01-26 à 17.48.55

Capture d’écran 2022-01-26 à 17.48.38

Are you using the autocomplete feature in the formula editing dialog to add the field names? I’m asking because the field containing the formula has spaces around the slashes—“Total Charges / m2 / an HT”—but the fields in your formula do not. Field references must be an exact match for the field name, including capitalization, spaces, etc.

Thanks Justin,
I’m not sure, name of the field with the spaces around the slashes is not included in the formula. But I changed it before including the IF(…,) in the formula, maybe that’s why ?
I followed your suggestion, and used the autocomplete feature -instead of copy-paste- and it works fine now ! :ok_hand: Solved.
Cheers from Nice, France !