Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
help with double counting please
Dear clever people of planet SS,
please see SS:
in this example, i have a customer who has asked to see four flavour varients of the same type of product, from which they will chose just one that will launch in their store. The volume forecast for this one line is 400,000 units with a sales value of £1.2m.
The challenge i have in reporting the size of the value and volume of the opportunity is that the the total volumes and values across all four lines are being assumed as the total opportunity ie 1.6m units and £4.8m sales. This is not the case as only one product will actually be chosen to take forward to launch. what i dont want to do is simple divide the opportunity by 4 ie 100k units and £300k sales because then once i have killed off the three lines not progressing I am left with one line where the volume and value of teh opportunity are being undervalued. similarly i dont want to leave any cells blank.
If this makes sense to anyone, then i'd appreciate any thouhts as to how i might manage this?
Thank you Si.