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
1677 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
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
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
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
0
dhavals
over 10 years ago
its fine, i have created rule function through "if" conditionand "IsNull()" and using that rule expression as of need for each date/decimal value to return empty if null else value. thanks.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel