I have a CDT with a number of fields one of which is a number. I wish to display

grantw over 10 years ago

I have a CDT with a number of fields one of which is a number. I wish to display the sum of this field as the default value in a form and have used the sum() function e.g. =sum(statement.amount). This however results in an ERROR:An error occurred while evaluating expression: =sum(pv!statement.amount) (Expression evaluation error at function 'sum' parameter 1: )

Is the summation of a field in a CDT not possible?...

Discussion posts and replies are publicly visible

0 shelzle over 10 years ago

Using the looping function "reduce" and a custom predicate function that adds the values should do the job.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 grantw over 10 years ago

Following further investigation there was an error in the CDT definition. The field amount was defined as a multi-value field. Once this was corrected the sum() function works.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel