I'm playing around with some data integrity formulas on the Account object and i'm stuck with a formula. I'm trying to review the percentage completeness of 5 account fields and return the result as a number. They are: Phone, Website, City, Postcode, Rating.
I'm struggling with the rating field as it is a Picklist field and i know that i need to use the TEXT function but i can't seem to get it to work. Here's what i have so far but i receive the 'Error: Syntax error. Missing ')
(IF(ISBLANK( Phone ),0,1)+IF(ISBLANK( Website ),0,1)+IF(ISBLANK( BillingCity ),0,1)+IF(ISBLANK(TEXT((Rating),0,1)+IF(ISBLANK( BillingPostalCode ),0,1))/5*100
Can anybody help me get passed this?
Main objective is to review the 5 fields, if they are populated then take 1, otherwise 0, sum them + divide the result by 5 to give a percentage.
Thanks in advance for any support!
Or more simply
IF(ISBLANK( Phone ),0, 0.20) +
IF(ISBLANK( Website ),0, 0.20 ) +
IF(ISBLANK( BillingCity ),0, 0.20 ) +
IF(ISBLANK(TEXT(Rating)),0, 0.20 ) +
IF(ISBLANK( BillingPostalCode ),0, 0.20 )
