Macro not working

[#1]

Dear Experts,

i have created a straight table with 4 dimensions and  four Expressions (Revenue,projected Revenue, Difference) revenue is Straight forward coming to Projected revenue is copy of Revenue. but when i use what if scenario  using input box on Projected Revenue the values are not reflecting

set theInputBoxValue = ActiveDocument.GetVariable("var_InputBox")

set FieldToModify = ActiveDocument.Fields("ProjectedSales_modified")--->projected Revenue

[fkeuroglian]

Hi, please can you put an example for us

it will be easier to help you

Fernando

[#3]

hi fernando,

suppose if Projected revenue is 2000 in straight table when i apply what-if analysis and i gave you the value 20% on the input box it should calculate projected revenue 2400 please guide me how to achieve this using macro..

[fkeuroglian · Accepted solution]

Hi, you don not have to use macro to have what you are looking

see this example

hope this help

Fernando

[#5]

hi fernad the file what you are given is showing the below error

"the license embedded in this document is not valid"