AnsweredAssumed Answered

Help with calculation

Question asked by Joanner on May 2, 2010
Latest reply on May 4, 2010 by fitch

Title

Help with calculation

Post

We have a database for timesheets/billings where the employee enters the quantity of hours, accommodations, mileage etc.,  and the rates are entered automatically via the rates table.  I'm running into a problem where the accommodation rate fluctuates and am trying to come up with a calculation such as: 

 

(lineItem_PRODUCT::EmpRate)  
and If  (order_lineItem_PRODUCT::ItemName="Accommodations (Hotel/Motel)" ; order_lineItem_PRODUCT::EmpRate= ( ORDER::Accommodation Rate ))

 

I've set up  a seperate area on the order where the employee enters the accommodation rate and I want that cost to be used in the portal row for accommodation.

 

Hopefully I've given enough information!

Joanne

Filemaker 10

Outcomes