1) In a query I'm converting this field: [IT32]
<CatchWeights><CatchWeight>21.65</CatchWeight><CatchWeight>25.45</CatchWeight><CatchWeight>23.25</CatchWeight><CatchWeight>21.1</CatchWeight></CatchWeights>
2) Into this for displaying on invoice: [INVOICECW]
|21.65|25.45|23.25|21.10|
3) I replace the pipes with a "+" [INV-T1] and add a zero in front and in back of the string: [INV-T2]
0 +21.65 +25.45 +23.25 +21.10 +0
4) And this to calculate totals field [Inv-T3]
Eval([Inv-T2])
The issue I have is in (4) when I have more than 65 values the eval fails, how can I get it to sum no matter how many values are entered?
<CatchWeights><CatchWeight>21.65</CatchWeight><CatchWeight>25.45</CatchWeight><CatchWeight>23.25</CatchWeight><CatchWeight>21.1</CatchWeight></CatchWeights>
2) Into this for displaying on invoice: [INVOICECW]
|21.65|25.45|23.25|21.10|
3) I replace the pipes with a "+" [INV-T1] and add a zero in front and in back of the string: [INV-T2]
0 +21.65 +25.45 +23.25 +21.10 +0
4) And this to calculate totals field [Inv-T3]
Eval([Inv-T2])
The issue I have is in (4) when I have more than 65 values the eval fails, how can I get it to sum no matter how many values are entered?