Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] FML Specific Column Calculations

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] FML Specific Column Calculations
 Login/Join
 
Gold member
posted
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
 
Posts: 93 | Registered: February 20, 2008Report This Post
Gold member
posted Hide Post
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
 
Posts: 93 | Registered: February 20, 2008Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] FML Specific Column Calculations

Copyright © 1996-2020 Information Builders