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

Welcome!

It looks like you're new here. Sign in or register to get started.
Sign In