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!