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
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..