I have an object with a bunch of fields and I want to run a report that will show the total number of records and how many or what percentage of each field is complete
16 answers
Sure, just convert the picklist value to a Text string using a TEXT function around the Field Name like this => IF( ISBLANK( TEXT( Picklist_Field_D )), 0 , 1)
(IF( ISBLANK( Text_Field_A ), 0 , 1) +
IF( ISBLANK( Date_Field_B ), 0 , 1) +
IF( ISBLANK( Number_Field_C ), 0 , 1) +
IF( ISBLANK( TEXT( Picklist_Field_D )), 0 , 1) +
IF( ISBLANK( Currency_Field_E ), 0 , 1)) / 5
