Skip to Content
0
Former Member
Dec 02, 2006 at 11:39 PM

Fox formula debug??

22 Views

Hi all,

I am a begining learner for Fox. Can someone point out what's wrong with my Fox formula? It is not working when I run it.

Row 1: Sales Reveune (acct: 430000; KF:0amount; input field for forecasting)

Row2: Sales Tax rate (acct: 790200, KF:zrate; input filed for forecasting)

<b>Row3: Sales Tax (acct: 7902000, KF:0amount; need to store in the cube)</b>

<b>Lead column: G/L account & KF

Data column: Fiscal period year</b>

Field to be changed: <b>KF names, G/L account, and Fiscal period/ year</b>

Field to be condition: N/A

Fox formula:

DATA PER TYPE 0FISCPER.

DATA GL TYPE 0ACCT.

FOREACH PER.

IF GL = 430000.

{0AMOUNT,PER,0000790200} =

{0AMOUNT,PER,430000} * {ZPERUNIT,PER,0000790200} /100.

ENDIF.

ENDFOR.

Thank you

J.