Formula to calculate expression box x (multiply) text box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

badleg - 06 Mar 2006 15:41 GMT

I am trying to create a Service Work Order sheet that will add hours worked
for the week, then multiply the total hours worked by a dollar amount. I
figured out how to get the hours added up. The expression box has NaN
displayed in create mode but shows the total hours in Preview.

How do you indicate a expression box value and multiply that value by a Text
box value? Or is there a better way to do this?

Reply to this Message

Adam Harding - 08 Mar 2006 10:59 GMT

Badleg

Expression boxes are static data and as such cannot be referenced to do
calculations on they do not in Infopath's reality exist. Change the
expression box to a text box and do it that way.

Cheers Adam

> I am trying to create a Service Work Order sheet that will add hours worked
> for the week, then multiply the total hours worked by a dollar amount. I
[quoted text clipped - 3 lines]
> How do you indicate a expression box value and multiply that value by a Text
> box value? Or is there a better way to do this?

Reply to this Message