Skip to main content
Topics#Data ManagementPregunta de Davina Hanchuck
Davina Hanchuck (SGI, Tampa User Group Co-Leader) ha preguntado en #Data Management
2 nov 2011, 15:41

Formula Help

Trying to create a formula field that will calculate a total number of current members by using values in a picklist field.

 

If  type of member is complete,advanced,core,honorary give a value of 1

 

Any help on how to set this up is appreaciated.

 

Thanks in advance!!
3 respuestas
  1. Steve Molis (You Owe Me a Beer, Inc.)
    2 nov 2011, 15:50
    Here you go

     

    CASE(MemberType__c,

     

    "complete", 1 ,

     

    "advanced", 1,

     

    "core", 1,

     

    "honorary", 1,

     

    0) 

     

    Then create a Rollup Summary field that returns the SUM of your Formula Field result.
Escribir una respuesta...
0/9000