Don't Know

barski · July 20th, 2007, 12:01 PM

here's some sample data to try and explain my problem

Input

Code:

<company>
   <unit>
      <unitno>1111</unitno>
      <category>Housewares</categroy>
      <employees>2</employees>
      <sales>
           <periodone>1000</periodone>
           <periodtwo>2000</periodtwo>
           <periodthree>0</periodthree>
           <periodfour>1</periodfour>      
      </sales>
   </unit>
   <unit>
      <unitno>1111</unitno>
      <category>Garden</categroy>
      <employees>1</employees>
      <sales>
           <periodone>400</periodone>
           <periodtwo>200</periodtwo>
           <periodthree>90</periodthree>
           <periodfour>50</periodfour>      
      </sales>
   </unit>
    <unit>
      <unitno>1111</unitno>
      <category>Automotive</categroy>
      <employees>3</employees>
      <sales>
           <periodone>2500</periodone>
           <periodtwo>3000</periodtwo>
           <periodthree>1680</periodthree>
           <periodfour>0</periodfour>      
      </sales>
   </unit>
</company>

Output
periodname sales employees
periodone 3900 6
periodtwo 5200 6
periodthree 1770 4
periodfour 51 3

I have no problem getting the output for the first two columns(periodname,sales). However, if the sales for that period are zero then the employees should be excluded (periodthree, periodfour). I can't figure the way to sum because the predicate that needs to be applied [period1!=0] is a level below the number i want sum(employees). Any help would greatly appreciated!

FYI this is just a sample. In reality the number and name of the children for sales varies. However, I've handled all those issues but this one has me stumped.

mhkay · July 20th, 2007, 12:09 PM

It would be useful to see your existing code to see what approach you are using to the overall structure, this may affect the answer.

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

barski · July 20th, 2007, 12:54 PM

i had to replace several things for confidentiality reasons so hopefully i got all the names changes right.

Code:

   <table>
       <xsl:for-each select="msxsl:node-set($unitnodes)/unit[generate-id(.) = generate-id(key('KeyUnit',unit)[1])]" > 
          <xsl:variable name="coid" select="./unitno" />              

              <xsl:for-each select="./sales/*" >
               <xsl:variable name="periodname" select="name(.)" />
               <xsl:variable name="salesamount" select="sum(msxsl:node-set($unitnodes)/unit[unitno=$coid]/sales/*[name()=$periodname])" />                
               <tr> 
                   <td><xsl:value-of select="$coid" /></td>                                                      
                   <td><xsl:value-of select="$periodname" /></td>
                   <td><xsl:value-of select="format-number($salesamount,'###,##0.')"/></td>
                       <xsl:choose>
                          <xsl:when test=". &gt; 0">                             
                             <td><xsl:value-of select="" /></td>                                                      
                          </xsl:when>
                          <xsl:otherwise>
                             <td>0</td>
                          </xsl:otherwise> 
                       </xsl:choose>
            </tr>    
             </xsl:for-each>

       </xsl:for-each>
</table>