Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Counting Confusion

I created a table to show records that have a count of 2 or more:   But when looking at my tables from the editor, I see these records only once:   What on my table could be causing...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • dramus's avatar
    dramus
    8 years ago

    I can see it returning more than one, based on how the count was created. E.g. if you took the service out, it could produce more than one row. 

     

    Try creating a table with all the columns in it (cs.co,cs.service, cs.servicelevel,cs.startdate,cs.endDate,einfo.id,empstatus), my guess is you have two different SeviceLevels, einfo.id or empStatus, or something.

dramus's avatar
dramus
Continued Contributor
8 years ago

I can see it returning more than one, based on how the count was created. E.g. if you took the service out, it could produce more than one row. 

 

Try creating a table with all the columns in it (cs.co,cs.service, cs.servicelevel,cs.startdate,cs.endDate,einfo.id,empstatus), my guess is you have two different SeviceLevels, einfo.id or empStatus, or something.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

dramus That was exactly it. The record was in 2 different company sets which I was unaware of. Thank you for your help!