AnsweredAssumed Answered

Help with calculation

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


Help with calculation


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: 


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!


Filemaker 10