Skip to main content
Topics#Data ManagementPregunta de Davina Hanchuck
Davina Hanchuck (SGI, Tampa User Group Co-Leader) ha preguntado en #Data Management
30 may 2014, 16:46

Formula Help - What am I missing?

Can't figure out what I'm missing in my formula. This is a number formula field.

 

I'm trying to: Give a 1 if the Cancellation date is in 2014 and the Cancellation Type is "30 day cancel", else give a 0.

 

Here is my formula:

 

IF(

 

(AND

 

(YEAR( Cancellation_Date__c ) = 2014),

 

ISPICKVAL(Reason_For_Cancellation_Type__c, "30 Day Cancellation")),

 

1,0)

 

What am I missing?
3 respuestas
  1. Deepak K Anand (‎‎‎‎‎‎Zoom Communications, Inc.)
    30 may 2014, 16:52
    You could write something like this:

     

    IF(
      AND(
        YEAR(Cancellation_Date__c) = 2014,
        ISPICKVAL(
          Reason_For_Cancellation_Type__c,
          "30 Day Cancellation"
        )
      ),
      1,
      0
    )
Escribir una respuesta...
0/9000