XPath in XQuery: Casting to xs:decimal

This works well for me

fn:sum($asset/(in:currentprice * in:quantity))

Open in new window


But I have tried to convert this to an xs:decimal as follows, but they do not work:

fn:sum($asset/(in:currentprice * in:quantity))/xs:decimal()

fn:sum($asset/(in:currentprice * in:quantity)/xs:decimal())

Open in new window


How can I cast the following XPath statement to xs:decimal ?

fn:sum($asset/(in:currentprice * in:quantity))

Open in new window


Thanks
Anthony LuciaAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Geert BormansConnect With a Mentor Information ArchitectCommented:
If the casting to decimal is a precision issue,
you need to cast prior to the calculation in order to obtain correct results

fn:sum($asset/(in:currentprice/xs:decimal() * in:quantity/xs:decimal()))

I
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.