Forum Discussion

EHEH's avatar
EHEH
Qrew Cadet
7 years ago

I want a Numeric formula field to be blank

I am using one form to calculate two values (emails and phones). There are two fields to calculate these number, 1- Sum of emails, 2- Sum of phones. If i'm calculating emails I need the Sum of phones to be blank not 0. Is there any way to achieve that. I tried an If formula, so if the type is Phone the value of the field to be "", but it's giving errors. 

my formula:
If(
="Phone calls","",
=-100,0,
=-100,0,
100-)
  • DavidBrogdon's avatar
    DavidBrogdon
    Qrew Assistant Captain
    What errors is it giving? Can we get a screenshot? It is not clear to me what you are trying to accomplish.