I am having some output issues with a formula I am using and was wondering if you guys could help... the output has been in different formats like 100 or 200 while others in the same column are 10*10 or 10*20. How do I get the formula to simplify 10*10 to 100 on all of the rows?
Any suggestions?
<xsl:choose>
<xsl:when test="INVOICE_CURRENCY = 'GBP'"><xsl:value-of select="INVOICE_REVENUE_TRANS"/></xsl:when>
<xsl:otherwise><xsl:value-of select="INVOICE_REVENUE_TRANS"/>*<xsl:value-of select="CONV_RATE_TO_LEDGER_CURR_SALES"/></xsl:otherwise>
</xsl:choose>