Using input value for projection

[300sss300]

HI,

suppose I have following 04 data fields

1. Purchased Quantity (PQ), 2. Purchased Value (PV), 3. Sale QTY (SQ) & Sale Value (SV)

now lets say Sum(PQ) = 100 and Sum(PV) = 1,000

till date sum(SQ)=40, & Sum(SV)=600

I wanna use any Sale price as input which should show me margin above PV after multiplying with remaining PQ (60)

For example:

when the input value is 20 it should auto calculate projected margin above PV(1000) as in this case Input value*(Sum(PQ)-Sum(SQ))+Sum(SV)-Sum(PV) if it is 20 then output should be 1000(20*60+800-1000)

How to link this input value to an expression in a straight table or text box or a button so that when I change the value it should show the result for my projected Margin based on remaining QTY.

Thanks

[dplr-rn · Accepted solution]

Did you try to Declare and use a variable e.g. vInputValue use this in input box

Your expression can be
vInputValue*(Sum(PQ)-Sum(SQ))+Sum(SV)-Sum(PV)

Hope I understood the issue correctly

[300sss300]

Thanks