Report totals formula
Hi,
I have an example below. On my report, months remaining for each store is correct, based on inventory/sales pace per month. However, in the total, I cannot add the months remaining to get an accurate number, which the report is trying to do. (It doesn't work if any of the sales pace numbers are below 1. I need to divide the inventory total by the sales pace per month total to get the right number. How should I accomplish this?
Best Answer
-
Thank you!
Answers
-
@measterbrooks your table looks accurate and calculation.
Result=Inventory Total/Sales Pace Per Month= 45/0.3 =150 months
This means it would take 150 months to deplete the inventory at the given sales pace.
-
Yes, and thank you for the response. I cannot get a Smartsheet report to do this. In a report I only have the option for the following. What I desire is an option to do 89/11.3. I don't think I can do this.
-
You cannot do this in report. You have to do this in main sheet.
-
Thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!