FOX logic - how to link analysis item cell & button used in WAD

[Former Member]

Hi Experts,

I need to write FOX for following logic:

I am using 3 char. in row & 0FISCPER, 1 kf in column of input ready query. I have assigned this query to analysis item in web template. kiyfigure data is displayed in accordance with 0FISCPER.

eg. JULY2009 AUG2009 ...... JUN2010

CHAR. KF value KF value ...... KF value

1. Now, if user enters any value in kf cell of analysis item I need to pass this value to a button which holds FOX function.

2. Also, in FOX I have to write code for below logic.

If user enters any value in Aug2009 column i want to copy this value to other cells for months after AUG2009 till June2010. It should not copy kf value for months coming before Aug2009.

Kindly let me know how to achieve this.

Thanks,

Shamkant

[Former Member · Accepted solution]

Hi Shamkanth,

Ty this..

DATA VAR TYPE 0FISCPER.

• READ CURRENT MONTH OR PERIOD FROM WHERE YOU WANT TO COPY FROM

VAR = VARV ( VAR ) .

*IN YOUR CASE

DO 2 TIMES.

{KEYFIGURE TRGT,VAR} = {KEYFIGURE SOURCE,VAR}.

TMVL ( VAR ,1).

ENDDO.

**NOTE :

PLEASE CHAGE LOGIC ACCORDING TO REQUIREMENT

[Former Member · Accepted solution]

Hi,

Thanks for the reply.

My problem is resolved.

I have used 2 forloops (package & 0FISCPER) & called variable on fiscal year in code.

Thanks,

Shamkant