Skip to Content
1
Sep 26, 2013 at 08:28 PM

Sum of Double value in Xpath

111 Views

Hi,

In 12.2, we have an issue in SUM function in XPATH in transaction. Sum function is working fine for small double values but for large double values has exp it is showing value as NA.

<?xml version="1.0" encoding="UTF-8" standalone="no"?>

<Rowsets DateCreated="2013-09-26T13:36:30" EndDate="2010-12-22T14:31:00" StartDate="2010-12-22T14:31:00" Version="12.1">

<Rowset>

<Columns>

<Column Description="" MaxRange="1" MinRange="0" Name="DoubleCol" SQLDataType="8" SourceColumn="DoubleCol"/>

</Columns>

<Row>

<DoubleCol>2.160445391E7</DoubleCol>

</Row>

<Row>

<DoubleCol>5.460645391E7</DoubleCol>

</Row>

</Rowset>

</Rowsets>

For this XML as input param xmlin and in transaction, if we are using

Transaction.xmlin{sum(/Rowsets/Rowset/Row/DoubleCol)}

it is giving value as NA. But if DoubleCol value is small (like 10000,20000), it is showing sum result.

How to solve this issue.

Regards,

Senthil