Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi, you don not have to use macro to have what you are looking
see this example
hope this help
Fernando
Hi, please can you put an example for us
it will be easier to help you
Fernando
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..
Hi, you don not have to use macro to have what you are looking
see this example
hope this help
Fernando
hi fernad the file what you are given is showing the below error
"the license embedded in this document is not valid"