Guest User

Untitled

a guest
Nov 24th, 2017
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.81 KB | None | 0 0
  1. IF(
  2. TEXT(Practitioner_Group__c) = "Consultant",
  3. "C",
  4. "X"
  5. ) +
  6.  
  7. IF(
  8. MailingCity = "London",
  9. "L",
  10. "X"
  11. ) +
  12.  
  13. CASE(
  14. Practitioner_Speciality__c,
  15. "Orthopaedic", "A",
  16. "Neurosurgery", "B",
  17. "Neurology", "C",
  18. "Rheumatology", "D",
  19. "ENT", "E",
  20. "Sports Medicine", "F",
  21. "Pain Medicine", "G",
  22. "X"
  23. ),
  24.  
  25. /*Valid Status(S), Consultant(C), London(L) and one of the valid specialities(A-G).*/
  26. "SCLA", "3",
  27. "SCLB", "3",
  28. "SCLC", "2",
  29. "SCLD", "2",
  30. "SCLE", "2",
  31. "SCLF", "2",
  32. "SCLG", "2",
  33.  
  34. /*Valid Status(S), Consultant(C), London(L) and no speciality(X)*/
  35. "SCLX", "1",
  36.  
  37. /*Valid Status(S), Consultant(C), not from London(X) and one of the valid speciality(A-G.*/
  38. "SCXA", "2",
  39. "SCXB", "2",
  40. "SCXC", "2",
  41. "SCXD", "1",
  42. "SCXE", "1",
  43. "SCXF", "1",
  44. "SCXG", "1",
  45.  
  46. NULL
Add Comment
Please, Sign In to add comment