XPath in XQuery: Scientific notation

XPath in XQuery:  Scientific notation

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>

Open in new window


I then use the following statement:

fn:sum($Accounts/in:IndividualAcct[in:AcctType = 'AttcRec']/in:balance)

Open in new window


One of my summations results in the following in scientific notation:

1.08531525E6

Open in new window


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
Anthony LuciaAsked:
Who is Participating?
Advertise Here
 
Geert BormansConnect With a Mentor Information ArchitectCommented:
you need format-number() to get rid of the scientific notation

format-number(fn:sum($Accounts/in:IndividualAcct[in:AcctType = 'AttcRec']/in:balance * in:amount), '0.00')
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.