Report totals formula

measterbrooks

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?

measterbrooks

Thank you!

Bira

@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.

measterbrooks

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.

Bira

@measterbrooks 

You cannot do this in report. You have to do this in main sheet.

measterbrooks

Thank you!