Skip to main content
Topics#Data ManagementDavina Hanchuck의 질문
Davina Hanchuck (SGI, Tampa User Group Co-Leader) 님이 #Data Management에 질문했습니다
2014년 5월 30일 오후 4: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개
  1. Deepak K Anand (‎‎‎‎‎‎Zoom Communications, Inc.)
    2014년 5월 30일 오후 4: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
    )
답변을 작성하세요...
0/9000