<rss version="2.0" xmlns:a10="http://www.w3.org/2005/Atom"><channel><title>Inflectra Customer Forums: Help with Custom Reports - Percentage Calculation (Thread)</title><description>&#xD;
I am trying to get percent calculations to appear in excel when generating the test set summary report.  I followed the coding provided by the infectra documentation, but it didn't generate correctly...I'm attaching the report that generated! So, how would I get the percentages to show up and not be NaN%        I used this code: &#xD;
&#xD;
     &#xD;
&#xD;
     &#xD;
&#xD;
         &#xD;
&#xD;
           &#xD;
&#xD;
             &#xD;
&#xD;
             Test Set #   &#xD;
&#xD;
             Name   &#xD;
&#xD;
             Description   &#xD;
&#xD;
             Status   &#xD;
&#xD;
             Release   &#xD;
&#xD;
             Creator   &#xD;
&#xD;
             Owner   &#xD;
&#xD;
&#xD;
&#xD;
&#xD;
&#xD;
               # Passed   &#xD;
&#xD;
             # Failed   &#xD;
&#xD;
             # Caution   &#xD;
&#xD;
             # Blocked   &#xD;
&#xD;
             # Not Run   &#xD;
&#xD;
         % Passed   &#xD;
&#xD;
      %&#xD;
Failed   &#xD;
&#xD;
&#xD;
&#xD;
               &#xD;
&#xD;
                 &#xD;
&#xD;
                   &#xD;
&#xD;
                 &#xD;
&#xD;
               &#xD;
&#xD;
             &#xD;
&#xD;
             &#xD;
&#xD;
               &#xD;
&#xD;
                 &#xD;
&#xD;
                TX   &#xD;
&#xD;
                 &#xD;
&#xD;
                 &#xD;
&#xD;
                   &#xD;
&#xD;
                  padding-left:  px;  &#xD;
&#xD;
                   &#xD;
&#xD;
                   &#xD;
&#xD;
                     &#xD;
&#xD;
                       &#xD;
&#xD;
                     &#xD;
&#xD;
                   &#xD;
&#xD;
                   &#xD;
&#xD;
                     &#xD;
&#xD;
                   &#xD;
&#xD;
                 &#xD;
&#xD;
                 &#xD;
&#xD;
                   &#xD;
&#xD;
                 &#xD;
&#xD;
                 &#xD;
&#xD;
                     &#xD;
&#xD;
                 &#xD;
&#xD;
                 &#xD;
&#xD;
                   &#xD;
&#xD;
                 &#xD;
&#xD;
                 &#xD;
&#xD;
                   &#xD;
&#xD;
                 &#xD;
&#xD;
                 &#xD;
&#xD;
                     &#xD;
&#xD;
                 &#xD;
&#xD;
&#xD;
&#xD;
&#xD;
&#xD;
&#xD;
&#xD;
&#xD;
&#xD;
&#xD;
&#xD;
                 &#xD;
&#xD;
                   &#xD;
&#xD;
                 &#xD;
&#xD;
                 &#xD;
&#xD;
                   &#xD;
&#xD;
                 &#xD;
&#xD;
                 &#xD;
&#xD;
                   &#xD;
&#xD;
                 &#xD;
&#xD;
                 &#xD;
&#xD;
                   &#xD;
&#xD;
                 &#xD;
&#xD;
                 &#xD;
&#xD;
                   &#xD;
&#xD;
                 &#xD;
&#xD;
             &#xD;
&#xD;
      %  &#xD;
&#xD;
        &#xD;
&#xD;
     &#xD;
&#xD;
        %  &#xD;
&#xD;
          &#xD;
&#xD;
&#xD;
&#xD;
                 &#xD;
&#xD;
                   &#xD;
&#xD;
                     &#xD;
&#xD;
                   &#xD;
&#xD;
                 &#xD;
&#xD;
               &#xD;
&#xD;
             &#xD;
&#xD;
           &#xD;
&#xD;
         &#xD;
&#xD;
     &#xD;
&#xD;
&#xD;
&#xD;
</description><language>en-US</language><copyright>(C) Copyright 2006-2026 Inflectra Corporation.</copyright><managingEditor>support@inflectra.com</managingEditor><category domain="http://www.dmoz.org">/Computers/Software/Project_Management/</category><category domain="http://www.dmoz.org">/Computers/Software/Quality_Assurance/</category><generator>KronoDesk</generator><a10:contributor><a10:email>support@inflectra.com</a10:email></a10:contributor><a10:id>http://www.inflectra.com/kronodesk/forums/threads</a10:id><ttl>120</ttl><link>/Support/Forum/spiratest/issues-questions/1337.aspx</link><item><guid isPermaLink="false">threadId=1337</guid><author>Natasha Boruszok (natasha.boruszok@meritor.com)</author><category domain="http://www.inflectra.com/kronodesk/thread/tag">reporting</category><category domain="http://www.inflectra.com/kronodesk/thread/tag"> custom reports</category><title>Help with Custom Reports - Percentage Calculation</title><description>&#xD;
I am trying to get percent calculations to appear in excel when generating the test set summary report.  I followed the coding provided by the infectra documentation, but it didn't generate correctly...I'm attaching the report that generated! So, how would I get the percentages to show up and not be NaN%        I used this code: &#xD;
&#xD;
     &#xD;
&#xD;
     &#xD;
&#xD;
         &#xD;
&#xD;
           &#xD;
&#xD;
             &#xD;
&#xD;
             Test Set #   &#xD;
&#xD;
             Name   &#xD;
&#xD;
             Description   &#xD;
&#xD;
             Status   &#xD;
&#xD;
             Release   &#xD;
&#xD;
             Creator   &#xD;
&#xD;
             Owner   &#xD;
&#xD;
&#xD;
&#xD;
&#xD;
&#xD;
               # Passed   &#xD;
&#xD;
             # Failed   &#xD;
&#xD;
             # Caution   &#xD;
&#xD;
             # Blocked   &#xD;
&#xD;
             # Not Run   &#xD;
&#xD;
         % Passed   &#xD;
&#xD;
      %&#xD;
Failed   &#xD;
&#xD;
&#xD;
&#xD;
               &#xD;
&#xD;
                 &#xD;
&#xD;
                   &#xD;
&#xD;
                 &#xD;
&#xD;
               &#xD;
&#xD;
             &#xD;
&#xD;
             &#xD;
&#xD;
               &#xD;
&#xD;
                 &#xD;
&#xD;
                TX   &#xD;
&#xD;
                 &#xD;
&#xD;
                 &#xD;
&#xD;
                   &#xD;
&#xD;
                  padding-left:  px;  &#xD;
&#xD;
                   &#xD;
&#xD;
                   &#xD;
&#xD;
                     &#xD;
&#xD;
                       &#xD;
&#xD;
                     &#xD;
&#xD;
                   &#xD;
&#xD;
                   &#xD;
&#xD;
                     &#xD;
&#xD;
                   &#xD;
&#xD;
                 &#xD;
&#xD;
                 &#xD;
&#xD;
                   &#xD;
&#xD;
                 &#xD;
&#xD;
                 &#xD;
&#xD;
                     &#xD;
&#xD;
                 &#xD;
&#xD;
                 &#xD;
&#xD;
                   &#xD;
&#xD;
                 &#xD;
&#xD;
                 &#xD;
&#xD;
                   &#xD;
&#xD;
                 &#xD;
&#xD;
                 &#xD;
&#xD;
                     &#xD;
&#xD;
                 &#xD;
&#xD;
&#xD;
&#xD;
&#xD;
&#xD;
&#xD;
&#xD;
&#xD;
&#xD;
&#xD;
&#xD;
                 &#xD;
&#xD;
                   &#xD;
&#xD;
                 &#xD;
&#xD;
                 &#xD;
&#xD;
                   &#xD;
&#xD;
                 &#xD;
&#xD;
                 &#xD;
&#xD;
                   &#xD;
&#xD;
                 &#xD;
&#xD;
                 &#xD;
&#xD;
                   &#xD;
&#xD;
                 &#xD;
&#xD;
                 &#xD;
&#xD;
                   &#xD;
&#xD;
                 &#xD;
&#xD;
             &#xD;
&#xD;
      %  &#xD;
&#xD;
        &#xD;
&#xD;
     &#xD;
&#xD;
        %  &#xD;
&#xD;
          &#xD;
&#xD;
&#xD;
&#xD;
                 &#xD;
&#xD;
                   &#xD;
&#xD;
                     &#xD;
&#xD;
                   &#xD;
&#xD;
                 &#xD;
&#xD;
               &#xD;
&#xD;
             &#xD;
&#xD;
           &#xD;
&#xD;
         &#xD;
&#xD;
     &#xD;
&#xD;
&#xD;
&#xD;
</description><pubDate>Fri, 11 Dec 2015 20:23:25 -0500</pubDate><a10:updated>2015-12-23T16:43:32-05:00</a10:updated><link>/Support/Forum/spiratest/issues-questions/1337.aspx</link></item><item><guid isPermaLink="false">messageId=2433</guid><author>Inflectra Sarah (donotreply6@kronodesk.net)</author><title>&#xD;
Hi Natasha&#xD;
&#xD;
    The problem is that your field names are not correct, "FolderCountPassed" is for</title><description>&#xD;
Hi Natasha&#xD;
&#xD;
    The problem is that your field names are not correct, "FolderCountPassed" is for the test case list, this is the test set page so it would be just:        %          and           %          Regards        Sarah   </description><pubDate>Wed, 23 Dec 2015 16:43:32 -0500</pubDate><a10:updated>2015-12-23T16:43:32-05:00</a10:updated><link>/Support/Forum/spiratest/issues-questions/1337.aspx#reply2433</link></item></channel></rss>