Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
4 replies
Subscribers
7 subscribers
Views
1678 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
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....
OriginalPostID-77404
OriginalPostID-77404
Discussion posts and replies are publicly visible
Parents
0
revat.anandsongkit
Appian Employee
over 10 years ago
You should still be able to use the sum() function but instead of passing in one pv! as your array, you can create an array that consists of all your arguments e.g. sum(reject(fn!isnull, {pv!one, pv!two, pv!three,..., pv!twentyFive})).
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
revat.anandsongkit
Appian Employee
over 10 years ago
You should still be able to use the sum() function but instead of passing in one pv! as your array, you can create an array that consists of all your arguments e.g. sum(reject(fn!isnull, {pv!one, pv!two, pv!three,..., pv!twentyFive})).
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data