Skip to main content
Topics#CollaborationNeeraja Suribhatla의 질문
Neeraja Suribhatla (KQED) 님이 #Collaboration에 질문했습니다
2019년 10월 14일 오후 4:45

Birthyear

I need help with this formula field. I have a picklist field called birthyear. I am trying to calculate age range based on their birth year. Here is the formula. I didnt get any error message. I could not see the value on the field its empty. 

 

Thank you,

 

Neeraja

 

Birthyear

 

 
답변 11개
  1. Eric Praud (Polsource)
    2019년 10월 14일 오후 5:24
    Then use this instead:

     

    IF(VALUE(TEXT(Birth_Year__c))<1946, "Silent"

     

    IF(VALUE(TEXT(Birth_Year__c))<1965, "Boomers",

     

    IF(VALUE(TEXT(Birth_Year__c))<1977, "Generation X",

     

    IF(VALUE(TEXT(Birth_Year__c))<1996, "Millenials",

     

    IF(VALUE(TEXT(Birth_Year__c))>1995, "Generation Z", NULL)))))
답변을 작성하세요...
0/9000