You need to sign in to do that
Don't have an account?
Formula to count fields that have data in them
I am trying to do a count on the total fields that have data populated. However, I am getting a syntax error. Can anyone help?
(IF(ISNULL(Aetna_POS_Open__c ), 0, 1) +
IF(ISNULL(Assurant_John_Alden__c ), 0,1) +
IF(ISNULL(Avalon_Healthcare__c), 0, 1) +
IF(ISNULL(AVMED__c ), 0, 1) +
IF(ISNULL(Capital_Health__c ), 0, 1) +
IF(ISNULL(Cigna_PPO__c ), 0, 1) +
IF(ISNULL(Citrus__c ), 0, 1) +
IF(ISNULL(Humana__c ), 0, 1) +
IF(ISNULL(Florida_Health_Plan__c ), 0, 1) +
IF(ISNULL(Medicaid__c ), 0, 1) +
IF(ISNULL(NHP__c ), 0, 1) +
IF(ISNULL(Total_Health_Care__c ), 0, 1) +
IF(ISNULL(UHC_Options_PPO__c ), 0, 1) +
IF(ISNULL(Vista_U65__c ), 0, 1) +
IF(ISNULL(BCBS_Preferred_Patient_Care_PPO__c
), 0, 1))