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
1679 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
bhanuprakashg
over 10 years ago
you can make use of looping function reject
=sum(reject(fn!isnull,ri!inputarray))
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
bhanuprakashg
over 10 years ago
you can make use of looping function reject
=sum(reject(fn!isnull,ri!inputarray))
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data