Skip to main content The Trailblazer Community will be unavailable from 2/1/2025 to 2/2/2025. Please plan your activities accordingly.
Hi,

I'm trying to wrap my head around a particular problem.   We have some number fields, and these fields need to produce 2 things:  The number entered if they are filled out, and if they are not filled out a -1 answer.

So far I am using the following statement, which accomplishes 1/2 the job (getting -1 as an answer if blank).   Does anyone know how to bring the entered number into the results, should the field be filled out?

IF(ISBLANK(My_number field), '-1', '0')

Thanks for any leads.
4 answers
  1. May 9, 2015, 1:11 PM
    Sorry missed that!  This should do it:

     

    IF( ISBLANK( My_Number_Field__c ) , '-1', TEXT(My_Number_Field__c) )

     
Loading
0/9000