I am having difficulty in getting a total to be calculated in a text box in my report footer.
I have two calculated fields that are located in the report footer and work they are:
txtRITotal =Sum([Hours Worked]*6.31*24)
txtNXTotal =Sum([Fee])
They are both formatted to display as currency and they work perfectly as far as I can tell,
now the problem that I have is that I want to be able to take the results of those two fields
and add them together to make a Total field but,
=[txtRITotal]+[txtNXTotal]
only displays #Name?
I have tried numerous other different formulas and I always get #Name? as a result.
Can anyone assist please?