issue with format

anarleti · March 29th, 2010, 07:29 AM

Hi,

i am summing functional total value,

my source xml file contanins

<CF_LEDGER_CURRENCY>EUR</CF_LEDGER_CURRENCY>
<C_FUNCTIONAL_TOTAL>94,32</C_FUNCTIONAL_TOTAL>

in my xsl file i have writen like below for the column "betrag"

<element id="betrag"><xsl:value-of select="sum(key('group', concat(C_VAT_TAX_REG_NUM,C_CUST_NAME,C_TAX_REPORTI NG_NAME))/C_FUNCTIONAL_TOTAL)" /></element><xsl:text></xsl:text>

When iam runing the report
iam geting out put like , NaN

<element id="betrag">NaN</element>

as my functional total value is in 99,99 format how can i add these amounts in my XSl and show the out put

Thanks
Anil

Martin Honnen · March 29th, 2010, 07:36 AM

Is that XSLT 2.0? Then use e.g.

Code:

<xsl:value-of select="sum(key('group', concat(C_VAT_TAX_REG_NUM,C_CUST_NAME,C_TAX_REPORTING_NAME))/C_FUNCTIONAL_TOTAL/translate(., ',', '.'))" />

to convert e.g. 94,32 to 94.32.

mhkay · March 29th, 2010, 07:39 AM

You need to convert the numbers to the number format recognized by XSLT (and XML Schema).

In XSLT 2.0 you can do:

Code:

sum(key(.....)/translate(., ',', '.'))

If you're using XSLT 1.0 it's more difficult; to sum over values that are not represented directly in the nodes, but computed from the nodes, you typically need either a recursive scan over the nodes, or a two-pass solution.

anarleti · March 29th, 2010, 08:04 AM

Hi iam using Oracle XSLT version 2.0 only

but it is giving below error :

XML-22013: (Error) Error in expression: 'sum(key('group', concat(C_VAT_TAX_REG_NUM,C_CUST_NAME,C_TAX_REPORTI NG_NAME))/C_FUNCTIONAL_TOTAL/translate(., ',', '.'))'.

i mentioned like below,

<element id="betrag"><xsl:value-of select="sum(key('group', concat(C_VAT_TAX_REG_NUM,C_CUST_NAME,C_TAX_REPORTI NG_NAME))/C_FUNCTIONAL_TOTAL/translate(., ',', '.'))" /></element><xsl:text></xsl:text>

thanks
Anil

Martin Honnen · March 29th, 2010, 08:11 AM

I think it is best to use an Oracle forum then where someone is hopefully familiar with the quirks of that XSLT processor.
I think the suggestions made should work with any compliant XSLT 2.0 processor.
You could try whether

Code:

<xsl:value-of select="sum(for $e in key('group', concat(C_VAT_TAX_REG_NUM,C_CUST_NAME,C_TAX_REPORTING_NAME))/C_FUNCTIONAL_TOTAL return translate($e, ',', '.'))" />

works better but I am guessing as to what might or might not be supported by your processor.

mhkay · March 29th, 2010, 08:20 AM

I don't think the Oracle XSLT processor is a complete implementation of XSLT 2.0 - Check the oracle documentation for details.

anarleti · April 23rd, 2010, 09:57 AM

Hi,

it worked fine for me by using the below syntax

<xsl:value-of select="sum(for $t in current-group()/C_FUNCTIONAL_TOTAL return number(translate($t, ',.', '.')))"/>

Thanks
Anil