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, BobVThis 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