Hi, can I get a blank space/nothing instead of “0” as the result of a formula ?
Solved
How to avoid the display of null numbers?
+5Best answer by Elias_Gomez_Sai
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.
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.
+5You 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 !
+5You 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.
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 ?
+21It 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.
+5Are 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 !
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.