Sliders

[#1]

I got 3 sliders containing sales cost and quantity.

If i raise the sales or the cost it affects the GP outcome 100% but whenever i raise the quantity slider it doesnt affect the cost or GP outcome.

Can anyone PLEASE PLEASE PLEASE PLEASE HELP!!!!

[#2]

Please provice more details.

Best would be an example QVW!

[#3]

sliders are as follows

1.Sales= vSales2

2.Cost=vCost2

3.Quantity=vQuantity2

got a table underneath that displays the amounts. when the values are set to 0 they are right

e.g.

And when i move the sales or cost slider it affects the GP

e.g

But if i only move the quantity slider, then the GP as well as the Cost doesnt change

e.g.

[#4]

Formula in the What if Table.

1.Sales= $(vSales) * (1 + vSales2/100) where $(vSales) = Sum(Sales)

2.Cost=($(vCost) * (1 + vCost2/100)) Where $(vCost)=Sum(cost)

3.GP=$(vSales) * (1 + vSales2/100) - $(vCost) * (1 + vCost2/100)

4.Quantity=$(vQuantity) * (1 + vQuantity2/100)

5.GP%=$(vSales) * (1 + vSales2/100) - $(vCost) * (1 + vCost2/100)

[#5]

cnt seem to figure it out?

[#6]

This might seem a bit obvious, so maybe I'm missing something that I should be seeing:

Your formula for Cost and your formula for GP does not have any reference to Quantity, so I'm struggling to know how those values would change when you slide quantity. I would imagine that your quantity column changes, but unless you create some reference to vQty in the GP & Cost formulas, it simply wont change them.

Let me know if I've missed something glaringly obvious!

[#7]

Hi Nigel.

U are correct but i cnt seem to put quantty n either of them coz the data come out wierd.

Got any suggestions?

[#8]

anyone got any ideas?

[#9 · Accepted solution]

Hi

I'm assuming that quantity has an impact on sales, but that the value Sales is already resolved in the load script by multiplying a price by a quantity, and that the same goes for cost.

If the above is the case then you cannot execute a What If on quantity, because you have no idea what price to multiply the quantity by in order to come with a new value for both cost and sales.

If your original expression was something like:

=Sum(Price * Quantity)

and

=Sum(UnitCost * Quantity)

Then you could introduce quantity into the what if scenario by executing a modification formula on both aspects of the above.

Other than that, you would need to execute a whatif using an average price, for example:

( Original Sales/Original Quantity ) * WhatIfQuantity.

Final answer really depends on what you want to achieve.

[#10]

Hi Nigel

Yea I gave up on that. Thanks for helping anyways.