Ability to Add Calculations Across Columns in Reports (Horizontal)
I'd like to see a calculation added that allows us to perform a calculation on column calculations in a report.
For example, if I have a field with job income and fields with job expenses such as materials, subcontractors, etc. I can calculate the sum of income and the sum of each of the expenses using the calculate button in a report. I would like to take this one step further and be able to do a final calculation of subtracting all of the expenses from the income to see the P&L of a job.
I know JobNimbus has it's own financial section per job; however, if I use JobNimbus' financials, it doesn't map properly to my QuickBooks Online so I had to turn it off. I don't want to spend time doing double entry, and I don't like that I can't type my own invoice numbers or purchase order numbers (to match the ones actually sent to the customer via QuickBooks) in JobNimbus. It would be so much easier if the solution involved fixing JobNimbus' financial section to sync better with QuickBooks or allow for invoice amounts and expenses just to be entered as one line items with a spot to manually enter the invoice/purchase order number, without detailed transactions in the financials; but in the meantime, a quick calculation to select column calculations would be helpful!
Sherri Simms
shared this idea
Not enough community interest.