Adding Values - Check If Numeric

In and IDM template, I'm adding the value of two XPaths. This works fine 99% of the time, but there are some circumstances where one of these two values is blank / null. (The XPath exists, but the value is blank.)

This of course throws an error.

I need a way of only adding these values if they're numeric.

I've yet to been able to come up with a way to do it.

Any suggestions of a way to do this in an IDM template?

Find more posts tagged with

Infor Document Management (IDM)

Accepted answers

All comments

Do you have an example?

Aaron Roma

I've cut out the relevant parts of the XML here. Normally, this is XML data:

<dsAcknowledgement xmlns:xsi="">www.w3.org/.../XMLSchema-instance">
<AckHeader>
<AckLine>
<LineNo>1</LineNo>
<UnitPrice>170.6349</UnitPrice>
<DiscountAmt>34.12698</DiscountAmt>
</AckLine>
</AckHeader>
</dsAcknowledgement>

I'm taking the value from UnitPrice and subtracting DiscountAmt.

There are a few occasions where it will come through will a blank UnitPrice value, like this:

<dsAcknowledgement xmlns:xsi="">www.w3.org/.../XMLSchema-instance">
<AckHeader>
<AckLine>
<LineNo>1</LineNo>
<UnitPrice xsi:nil="true"/>
<DiscountAmt>0.0</DiscountAmt>
</AckLine>
</AckHeader>
</dsAcknowledgement>

I need to be able to apply the calculation only if the UnitPrice isn't nil.

Copyright © 2025 Infor. All rights reserved.