Balance Totals

[mommom]

Good Morning,

I have a Travel Request Form that I have a beginning balance and an ending balance.

In the ending balance field I put the following:

=[BeginningBalance]-[RentalVehicle]-[LocalTravel]-[FlightAmount]+[FlightAmount1]-[M&IE]*[M&IE1]-[Mileage]*[MileageTotal1]

I am getting an error message. If someone could please help me and let me know what I am doing wrong?

 

[randy700]

What is the error message?

 

[mommom]

Good Morning Randy?

It had the #NAME?, but I figured it out.

But I do have another question. Is there a way to have your ending balances carry over to a new form as the beginning balance?

 

[randy700]

I'd store it somewhere, either in a global variable or, better yet, a table.

 

[tracy1234]

Probably nothing to do with your error message, but surely you want to throw some "()'s" into the equation to help properly evaluate the calculation?

Also FlightAmount, FlightAmount1, M&IE, M&IE1 gives the impression that you may have some normalizaion issues that may not have direct bearing on this current error, but will most likely need to be addressed.

-Tracy

 

[mommom]

Randy,

I do not understand when you say that you would store it in a table?


Tracy,

What type of normalization issues will I encounter?

 

[randy700]

When you say you want to carry the ending balances over to a new form... do you mean the next record or an entirely different form?

 

[tracy1234]

Usually when someone posts field names that are incremented - you posted FlightAmount and FlightAmount1 - it means that they have some normalization issues.

If you have a table somewhere that is set up like this:

my_table
---------------------------------------------------------
some_id   FlightAmount    FlightAmount1    FlightAmount2
---------------------------------------------------------
1           $200            $150              $270

then you have some normalization issues. This kind of table structure makes extracting data via queries difficult.

If this is the case with you, then there are all sorts of links on this site to help you with normalization. If this is not the case, then just ignore all this.

-Tracy

 

[mommom]

Good Afternoon Randy,

I would like for when I put the same person's name on a new form there previous ending balance would automatically appear as there beginning balance. Not sure if this is possible.

Thanks for all your help!

 

[randy700]

The ending balance is a calculated field, derived from 2 or more fields of actual data. Rather than "carrying over" the ending balance, you should put the formula on your new form.

That being said, I think you should consider Tracy1234's comments regarding normalization.