Anthony Lucia
asked on
XPath in XQuery: Scientific notation
XPath in XQuery: Scientific notation
I have an output XSD that looks like this:
I then use the following statement:
One of my summations results in the following in scientific notation:
I need to format this in such a way as to NOT use
scientific notation.
Can I use either fn:string or format-string().
How can I do this? Can I do this all on the same line as the fn:sum() statement. What would that look like?
Thanks
I have an output XSD that looks like this:
<xs:simpleType name="Money">
<xs:restriction base="xs:decimal">
<xs:fractionDigits value="2"/>
</xs:restriction>
</xs:simpleType>
I then use the following statement:
fn:sum($Accounts/in:IndividualAcct[in:AcctType = 'AttcRec']/in:balance)
One of my summations results in the following in scientific notation:
1.08531525E6
I need to format this in such a way as to NOT use
scientific notation.
Can I use either fn:string or format-string().
How can I do this? Can I do this all on the same line as the fn:sum() statement. What would that look like?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.