I am using "office 2007 document generator" service. In configuration

dhavals over 10 years ago

I am using "office 2007 document generator" service. In configuration setup of this service, parameters mapping (document parameter and process variables), i have used "sum" function. sum function has 25 arguments(process variables) to make sum. Now, if any argument having NULL value then sum got fail and unable to complete its execution process. Can any one share me how best way to achieve its null checking or some how resolve issue.
I want to consider value as a "0" if its not provided....

Discussion posts and replies are publicly visible

Parents

0 dhavals over 10 years ago

I don't have an array here as these are process variables individually and making sum. Also, i want same type of condition for date too while do formating example: text(reject(fn!isnull,pv!pvInspectionDate),"dd mmmm yyyy") as many type date is null so it throws exception.. Please suggest me how it could resolve ?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 dhavals over 10 years ago

I don't have an array here as these are process variables individually and making sum. Also, i want same type of condition for date too while do formating example: text(reject(fn!isnull,pv!pvInspectionDate),"dd mmmm yyyy") as many type date is null so it throws exception.. Please suggest me how it could resolve ?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data