So I am attempting to get a table total for one column from a table, to be displayed in a letter as part of a Word table. As far as I am aware this should be fairly straightforward by using
but all I am getting is 0.00. To clarify, I have the table set up on a screen and it shows the column totals there.
Code: Select all
I have also tried using TABLERESET to ensure I haven't accidentally selected some part of the table and I'm running off that. I'm getting the individual values just fine using TABLEPROCCESS.
Any ideas? Thanks!
EDIT: I have also tried pulling the value in from a maths field instead but that is also returning 0