1 Reply Latest reply: May 9, 2011 3:57 AM by Thomas Ljungström RSS

    Count number of values/strings and divide them

    JOAKIM HAGERWALD

      Hello

       

      I'm trying to create a Barchart where I want to count the number of values/strings in two fields and then divide one with the other. Example, Bikes per person.

       

      If i have one field containing the bikes and every row is a description of a bike owned by a person, every person is the id number of a person.

       

      I've tried the count(Bikes)/Count(Persons), but this just gives me "1" on the barchart as a value, and I know this is not the correct value. Both fields are primary keys if it matters.

       

      Any suggestions on how I can make this work?

       

      Thanks in advance!