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]

 

Thanks in advance!

Comments