I'm just learning about worksheets and have learned a lot on the forum. But i can't seem to find an answer to a very basic procedure.
I'm creating a Door schedule and have used the User Field 1 in each of the doors for the price. With ='Door'.'UserFld1' placed in the worksheet database header, each of the database subrows have the correct price and have been formatted with decimal and the leader $. But the database header row only shows the number of doors with a dollar sign in front.
How would i show the total price of all the doors in the last cell of the column? Is there a better way to do this that i'm missing?