10.2.1 Activity: Add Non Employee Expenses Module

NoAmazonAffiliation

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!

Mahalakshmi

Hi @NoAmazonAffiliation 

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