4 Replies Latest reply on Jun 27, 2015 6:40 AM by philmodjunk

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

    TXNewbie

      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