AnsweredAssumed Answered

ValueList Question - determining the % of check boxes selected per record.

Question asked by TXNewbie on Jun 26, 2015
Latest reply on Jun 27, 2015 by philmodjunk

Title

ValueList Question - determining the % of check boxes selected per record.

Post

Hello,

I have a value list of items.  This value list is used with one field. The field is configured as a CHECK BOX using the value list. 

What I want to do: calculate the % of boxes checked in each record.

What I can do: using ValueCount(), I can easily determine how many check boxes have been selected in each record.  

Help: How do I calculate the total number of check box items possible (would be the same for all records)? Once I have that number, then I can easily calculate the % selected for that field in each record.

Thanks for the assistance.  Greatly appreciated.

Mark 

 

 

 

Outcomes