How do I concatenate or join 8 numeric fields into one and make number add up for the final total. For scaning purposes, each row ends with a dollar amount and is set up as a one digit numeric field; have 8 of these. For example a row with $23,234,890 where each number is a numeric field. There can be 1 to 50 rows of these numbers.
Each row of numbers must add up to get a total number for that page. How do I accomplish this!
You can use the "Sum(n1 [,n2...])" FormCalc function to return the sum of the non-null values of the passed parameters. If you use the "Concat()" function you will concatenate the value strings not sum the values.
More information is contained LiveCycle Designer's "Scripting Reference" option under LiveCycle Designer's menu "Help" option.
If you can not use the comb field, use the "Substr(s1, n1, n2)" function to extract the individual digits from the grand totals formatted value or use the "Str(n1 [, n2 [, n3]])" function to convert the grand total number to a string.