I have a table with formCalc on each row.
The final column in each row is a total calculation of overtime costs. I want to add all of these final numbers together at the bottom.
The formCalc should be (a34+b34+c34+d34+e34+f34+g34+h34+i34) but for some reason, I keep getting the message that "a34 accessor is unknown". a34 is working fine in other calculations, so I removed a34 for trouble shooting and then it says "b34 accessor is unknown"
Am I missing something?
Row1.a34+Row2.b34 etc.
If you let LC number your rows automatically and leave the names of the cells the same you can use wildcards in the FormCalc:
ie: if your rows are auto-numbered Row1[0], Row1[1], etc. and you want to total a column with cells named "Total" you could use sum(Row1[*].Total[*])