I have an expense log where I log in all my expenses for a specific job. The log is broke down and sorted in to 4 categories, Sub Contractor, material cost, Non-material cost, and Equipment. It is log separated by a lay “Expense by Category. This totals each category for me. I then have a portal to my “Work Order” layout so I can see this information on one screen. This part works great.
Here is my issue:
I have a field on my Work Order layout called UofM (unit of measure). I use this to find out my unit cost for, Admin, Labor, etc. However, I cannot get it to calculate the 4 expenses categories from my portal. Is there anyway to make each Expense Category divide my the UofM field