Discussions

Expand all | Collapse all

I want a Numeric formula field to be blank

  • 1.  I want a Numeric formula field to be blank

     
    Posted 01-31-2019 14:47
    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])


  • 2.  RE: I want a Numeric formula field to be blank

    Posted 01-31-2019 15:49
    What errors is it giving? Can we get a screenshot? It is not clear to me what you are trying to accomplish. 


  • 3.  RE: I want a Numeric formula field to be blank

    Posted 01-31-2019 15:59
    Use null instead of the empty quotation marks.


  • 4.  RE: I want a Numeric formula field to be blank

     
    Posted 01-31-2019 16:08
    worked! thanks :)