There are 4 sheets in the enclosed Excel.
Sheet 1 - The output from the WEBI report, connected using the LO Connection. Column H - The calculation on the LO output. Field L4 - is the prompt.
Sheet 2 - Modified Prompt to 201012
Sheet 3- Modified Prompt to 201101
Sheet 4 - Modified Prompt to 201010
On changing the Prompt value, the Column H returns the "#REF!" error. Please help in resolving this problem.
Thanks in advance.
Edited by: Ashish Goel on Jan 6, 2011 3:38 AM