2 Replies Latest reply: Jan 22, 2015 1:18 AM by laicong zhang RSS

    problems about straight table

    laicong zhang

      Hi ,

      I met a problem when i made a straight table.

      The background is that there is a group with ten team members, and each of them has success or failure on solving cases. I made a straight table to display the success cases the handled and the success rate. The cases are divided into three kinds but i only want to calcluate two of them, so i need a straight table.   I use my expression but the results are the same for everyone--no individual result. And the dimension is set to 'member'

       

      Here is the expression:

       

      = num ( count ({<group={'a'},group={'b'},status={'success'},member=>} caseID)

      /

         count ({<group={'a'},group={'b'},status=,member=>} ), '#,##0.00%')

       

       

      Could you please help me on this?

      Many thanks and thanks in advance!