How to avoid the display of null numbers?

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

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.

1 Like

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 ?

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.

1 Like

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 !


This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.