hi all,
would request you to help me out in resolving the below issue please.
I have attached a file which has a table having a column called V_.
V_=((Avg([Volatility New]))-vol)+$(vpecent_1)
where vol and vpecent_1 are variables ,vpecent_1 is used in the slider.
now when my vol = 0 my column V_=Volatiliy column.(leaving the format as % etc)
I want to achieve another condition where my V_ becomes 0 when I reset it with a button or something.and it should increase or decrease with the variation in the volatility slider,like( 0+vpecent_1)
this is possible when vol=V_ so that it becomes 0 and only slider variable remains.
Is this possible??? can anyone help me out please?????
regards,
Sahana