IDM Property Editor: How to bypass Xpath NaN error

Hello everyone, I saw this error in my job management when I tried to print OIS199PF with custom template

[There was an error for GenerateFile 983051973413359481OIS199PF_0_0.pdf. Error cause is: Could not generate file. Failed to replace text in the plain text control Failed to parse input number. Input value: NaN, locale: ms_ID Unparseable number: "NaN"]

The Xpath that caused this is the one I marked red, it wants to use sum function and apply it for VFDIAM field which is marked with blue.

Any ideas how can we bypass this NaN error? for different occasion I did manage to use sum function normally with no issue

Find more posts tagged with

**General Discussion**

Accepted answers

All comments

Rene Bottern

Something like this:
SUM(if(/..../VFDIAM eq 'NaN') then 0 else ./.../VFDIAM)

0911060553270289.pdf

Kaneez Jowaheer

Can we use this xpath for version 1.0?

unknown

Hello Rene, thank you for the suggestion. I tried it to use it in my Xpath but unfortunately it didn't work. At first I tried to change the "SUM" into "sum" since for sum to work is to use lowercase, then after that I tried to write the long version of the Xpath like this:

sum(if(/M3OutDocument/DataArea/Document/Subdocument/Lines/Line/VFDIAM eq 'NaN') then 0 else ./M3OutDocument/DataArea/Document/Subdocument/Lines/Line/VFDIAM)

but I'm met with this error:

Below are the lists of Xpath that I have tried to write, but all of them can't be applied:

sum(if(/M3OutDocument/DataArea/Document/Subdocument/Lines/Line/VFDIAM eq 'NaN') then 0 else ./M3OutDocument/DataArea/Document/Subdocument/Lines/Line/VFDIAM)

sum(if(/M3OutDocument/DataArea/Document/Subdocument/Lines/Line/VFDIAM = 'NaN') then 0 else ./M3OutDocument/DataArea/Document/Subdocument/Lines/Line/VFDIAM)

sum(if(/M3OutDocument/DataArea/Document/Subdocument/Lines/Line/VFDIAM eq 'NaN') then 0 else /M3OutDocument/DataArea/Document/Subdocument/Lines/Line/VFDIAM)

sum(if(/M3OutDocument/DataArea/Document/Subdocument/Lines/Line/VFDIAM = 'NaN') then 0 else /M3OutDocument/DataArea/Document/Subdocument/Lines/Line/VFDIAM)

sum(if(/M3OutDocument/DataArea/Document/Subdocument/Lines/Line/VFDIAM eq 'NaN') then 0 else sum(/M3OutDocument/DataArea/Document/Subdocument/Lines/Line/VFDIAM))

sum(if(/M3OutDocument/DataArea/Document/Subdocument/Lines/Line/VFDIAM = 'NaN') then 0 else sum(/M3OutDocument/DataArea/Document/Subdocument/Lines/Line/VFDIAM))
------------------------------------------------------------------
sum(if(/M3OutDocument/DataArea/Document/Subdocument/Lines/Line/VFDIAM eq 'NaN') then 0 else 1)

sum(if(/M3OutDocument/DataArea/Document/Subdocument/Lines/Line/VFDIAM = 'NaN') then 0 else 1)

sum(if(/M3OutDocument/DataArea/Document/Subdocument/Lines/Line/VFDIAM eq 'NaN') then 0) else/M3OutDocument/DataArea/Document/Subdocument/Lines/Line/VFDIAM

sum(if(/M3OutDocument/DataArea/Document/Subdocument/Lines/Line/VFDIAM = NaN) then 0) else/M3OutDocument/DataArea/Document/Subdocument/Lines/Line/VFDIAM

Rene Bottern

Sorry, was not aware you were on V 1.0

Rene Bottern

Can you try something like this instead.

sum(/M3OutDocument/DataArea/Document/Subdocument/Lines/Line/VFDIAM[/M3OutDocument/DataArea/Document/Subdocument/Lines/Line/VFDIAM != 'NaN'])

Attachment_4583.zip

unknown

Thank you for the suggestion Rene, with the way how it is written we can apply it.. but unfortunately in Job Management the process still fails

[There was an error for GenerateFile 971077973560284285OIS199PF_0_0.pdf. Error cause is: Could not generate file. Failed to replace text in the plain text control Failed to parse input number. Input value: NaN, locale: ms_ID Unparseable number: "NaN"]

Copyright © 2025 Infor. All rights reserved.