# 10.2.1 Activity: Add Non Employee Expenses Module

I'm currently trying to add the formula for the Total row, and I'm wondering why the SUM and LOOKUP formulas I've tried are invalid or not working.

Here are the formulas I've plugged in so far:

'OTH01 Non Employee Expenses'.Total[SUM:'OTH01 Non Employee Expenses'.Shipping Costs, SUM:'OTH01 Non Employee Expenses'.Rent, SUM:'OTH01 Non Employee Expenses'.Utilities, SUM:'OTH01 Non Employee Expenses'.Shared Costs]

'OTH01 Non Employee Expenses'.Total[LOOKUP:'OTH01 Non Employee Expenses'.Shipping Costs, LOOKUP:'OTH01 Non Employee Expenses'.Rent, LOOKUP:'OTH01 Non Employee Expenses'.Utilities, LOOKUP:'OTH01 Non Employee Expenses'.Shared Costs]

'OTH01 Non Employee Expenses'.Total[SUM:'OTH01 Non Employee Expenses'.Shipping Costs * 'OTH01 Non Employee Expenses'.Rent * 'OTH01 Non Employee Expenses'.Utilities * 'OTH01 Non Employee Expenses'.Shared Costs]

'OTH01 Non Employee Expenses'.Total[LOOKUP:'OTH01 Non Employee Expenses'.Shipping Costs * 'OTH01 Non Employee Expenses'.Rent * 'OTH01 Non Employee Expenses'.Utilities * 'OTH01 Non Employee Expenses'.Shared Costs]

Tagged:

• If I'm not wrong you are calculating the total value of all the four line items into the total row. You can use simple addition to get the total value.

Formula: Total = Shipping Costs + Rent + Utilities + Shared costs.

Thanks,

Mahalakshmi

• Moved post to Academy & Training forum.