Name of Feature/Request: Calculated Fields in Reporting
What financial, time savings, or quality of life improvements will occur from this: Tenant is selling case of products and have a custom field for Units per Case. It would be great in reporting to have a calculated field (like Excel or Google Sheets) where we could say Unit Cost = Price/Units per Case.Things to Consider: This request goes beyond just case count, that was just one example. There are other ways we would like to use simple math like this in reporting - doing sales calculations, inventory math, etc.The value is dependent on the item, so it could be different for every item. Item 456 may be $16.00 with a case count of 20. The unit price would then be $0.80.The idea is we don’t want to create another custom field to hold this information because we are already at our limit for custom fields and forcing our users to enter it allows for a lot of possible human errorSuggested Alternative Solutions: Request can be achieved using UOMOriginal Description:
Attempted Solutions So Far: None Listed
Digging deep - Any additional Why behind this request / How was this accomplished before Striven in what system or software: None
StrivenID: 2918367