Focal Point
[SOLVED] FML Specific Column Calculations

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/5007058576

April 29, 2015, 10:25 AM
BobV
[SOLVED] FML Specific Column Calculations
Hi all,
trying my hand at FML reporting. Got a good start and kind of getting it, but need a little help.
Trying to apply calculations to specific columns with specific formats in each (if possible), but one column is not calculating.
Below is code I have (some from GUI). Everythis is ok except column 4 is not displaying any values for my "WHAT_IF" and "INCR" defined rows. But column 3 is fine (except with this code is formatting as D12CM when I want I8C):

TABLE FILE M1440A
SUM
LP_ID_CNT/I8C
ACCT_CNT/I8C
CURR_BAL_AMT/D12CM
FOR
DISP
'PLAN' AS 'No Contact' LABEL NO_CONTACT OVER
'RESP' AS 'Contact' LABEL CONTACT OVER
BAR OVER
'PLAN' OR 'RESP' AS 'Total Email' LABEL EMAIL_TOT OVER
'CONTROL' AS 'Control' LABEL CONTROL OVER
RECAP CTL_EM(2)/I8C=EMAIL_TOT / CONTROL;
CTL_EM(3)/D12CM=EMAIL_TOT / CONTROL;
OVER
RECAP WHAT_IF(3)/I8C=CONTROL * CTL_EM(2);
WHAT_IF(4)/D12CM=CONTROL * CTL_EM(2);
AS 'What If Control=Email' OVER
RECAP INCR(3)/I8C=EMAIL_TOT - WHAT_IF;
INCR(4)/D12CM=EMAIL_TOT - WHAT_IF;
AS 'Incremental Gain'
ON TABLE SET FORMULTIPLE ON
END

thanks,
BobV

This message has been edited. Last edited by: BobV,


WF (App Studio) 8.2.01m / Windows
Mainframe FOCUS 8
April 29, 2015, 12:12 PM
BobV
All-
I figure this out on my own, sorry for the knee jerk posting.
I updated my code using different column identifiers. Although the columns I need to calculate on the report output appear to be 3 and 4, I used 4 and 6. Don't understand this, but I'll just have to play around with it in the future knowing this:

TABLE FILE M1440A
SUM
LP_ID_CNT/I8C
ACCT_CNT/I8C
CURR_BAL_AMT/D12CM
FOR
DISP
'PLAN' AS 'No Contact' LABEL NO_CONTACT OVER
'RESP' AS 'Contact' LABEL CONTACT OVER
BAR OVER
'PLAN' OR 'RESP' AS 'Total Email' LABEL EMAIL_TOT OVER
'CONTROL' AS 'Control' LABEL CONTROL OVER
RECAP CTL_EM(2)/I8C=EMAIL_TOT / CONTROL;
AS ' ' OVER
RECAP WHAT_IF(4)/I8C=CONTROL * CTL_EM(2);
WHAT_IF(6)/D12CM=CONTROL * CTL_EM(2);
AS 'What If Control=Email' OVER
RECAP INCR(4)/I8C=EMAIL_TOT - WHAT_IF;
INCR(6)/D12CM=EMAIL_TOT - WHAT_IF;
AS 'Incremental'
ON TABLE SET FORMULTIPLE ON
ON TABLE NOTOTAL
ON TABLE SET BLANKINDENT ON
END

BobV


WF (App Studio) 8.2.01m / Windows
Mainframe FOCUS 8