I want a Numeric formula field to be blank

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • Answered
  • (Edited)
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(
[X]="Phone calls","",
[Y]=-100,0,
[Z]=-100,0,
100-[N])
Photo of EH

EH

  • 282 Points 250 badge 2x thumb

Posted 3 months ago

  • 0
  • 1
Photo of David Brogdon

David Brogdon

  • 1,222 Points 1k badge 2x thumb
What errors is it giving? Can we get a screenshot? It is not clear to me what you are trying to accomplish. 
(Edited)
Photo of Dan

Dan

  • 1,400 Points 1k badge 2x thumb
Use null instead of the empty quotation marks.
Photo of EH

EH

  • 282 Points 250 badge 2x thumb
worked! thanks :)