I have recently started using User defined XSLT to display my user defined Tables. I have a field that is a calculated column and its format should be .000 I use this as a winning % coulmn. The formula is IIF(win+loss=0, win/1 , win/(win+loss)) and it is a Decimal type field. When I apply the following xsl I get a result of NaN. How do I fix this?

<td class="stndtd">
        <xsl:variable name="NameOfValueColumn" select="udt:ValueColumn"/>
        <xsl:variable name="FieldTitle" select="udt:FieldTitle"/>
        <xsl:choose>
         <xsl:when test="$FieldTitle='W%'">
          <xsl:variable name="FieldValue" select="udt:Data[udt:UserDefinedRowId=$id]/*[name()=$NameOfValueColumn]" />  
          <xsl:value-of select="format-number($FieldValue,'.000')" disable-output-escaping="yes"/>
         </xsl:when>
         <xsl:otherwise>
          <xsl:value-of select="//udt:Data[udt:UserDefinedRowId=$id]/*[name()=$NameOfValueColumn]" disable-output-escaping="yes"/>  
         </xsl:otherwise>
        </xsl:choose>
       </td>

Stefan,

Thanks for your reply. This did not work. When I use this method

<xsl:variable name="FieldValue" select="udt:Data[udt:UserDefinedRowId=$id]/*[name()=$NameOfValueColumn]" />  
<xsl:value-of select="format-number($FieldValue,'.000')" disable-output-escaping="yes"/>
 

or this method

<xsl:value-of select="format-number(udt:w_x0025_,'.000')" />

They both return a NaN. Are calculated fields stores as numbers? is that the problem?

As far as you second question. I did not notice the XSL Generator button and in my case I am new to XSL and it was easier for me to look at examples and figure out how it works. I hope that helps.

Here is the XML for that column.

<Fields>

The win and loss columns are Integers.  This worked perfectly when I used the data grid mode. The only reason I moved to XSL was to provide a more detailed style.