Row Formulas for Excel

[LeonelSanchezJr]

I am developing a Webfocus report using Developer Studio version 7.1.4.

My report output is EXL2K and has 1 line of real data output. Then, I have 2 blank rows beneath the real data.


The report looks like this:
FIELD_A FIELD_B FIELD_C
100.00 200.00 700.00

RESERVE
OVER/UNDER

The report is a BATCH report and should allow the user to
enter a vlaue under FIELD_C on the 2nd row (RESERVE).
I want the FORMULA to reside on the 3rd row under FIELD_C.

The formula should be (ROW2 - ROW1) from FIELD_C.




Thanks,

Leo ;-)

 

[focwizard]

Is your user entering the value BEFORE execution, or into the Excel spreadsheet? Is the formula ONLY under FIELD_C?

 

[LeonelSanchezJr]

The user enters the value AFTER execution in the Excel spreadsheet.

Thanks,

Leo ;-)