Counting related items that match criteria

Follow

Jacob Robinson

• August 04, 2016 09:46

I have an app called invoices which has a number of related items in app B.

Each of these services falls into one of 3 categories and on the invoice I would like to calculate the total number of related items in each category.

 

Thank you for any help provided!

0

• 

  Jacob Robinson

  • August 08, 2016 17:01

  I have attempted using the following js code but it returns 0 when it should be returning 1:

   

  var type = @All of Key Stage;
  var count = 0;
  for(var i = 0; i < type.length; i++){
  if(type[i] == "KS3"){
  count++
  }
  else{
  count
  }
  };

   

  Any anyone help?

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • August 09, 2016 08:39

  Hi Jacob,

  the code looks ok, but you don't need the else-part:

  var type = @All of Key Stage;
  var count = 0;
  for(var i = 0; i < type.length; i++){
  if(type[i] == "KS3"){
  count++
  }};
  count

  Is Key Stage a single or a multi choice category? If multi choice: 

  if(type[i].indexOf("KS3") > -1 ){

  Rainer

  0

  Comment actions Permalink

Please sign in to leave a comment.