 |
|||||
|
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. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| Column manipulation in FML | Login/Join |
| Member |
I'm new to the WebFocus product and I'm trying to create a financial report using FML in Developer Studio 7.6.2. Is there a way to place two items on one tag line or assign a column based on a condition? WebFOCUS 7.6.2 DB2, V5R4 Output: PDF | ||
|
| Virtuoso |
If you mean budget and actual by "two items" then the answer is yes. "assign a column based condition" like "if the value in column C5 is higher then C6 then C7 must be red font on a white bg else yellow on a black bg" the answer is yes too.
| |||||||
|
| Member |
I need to back up a bit. How do I get data into C5 or C6? Right now all my data is showing in the same column, and only one per line. WebFOCUS 7.6.2 DB2, V5R4 Output: PDF | |||
|
| Expert |
Craig, In this example I am summating two values from the source data and then computing 5 more columns. In the RECAP I am replacing certain cells contents with a calculation by refering to the rows by the label that I attribute them with together with the column number. Check out the FML documentation, it is fairly easy to understand. TABLE FILE CAR
SUM RCOST
DCOST
COMPUTE COL4/D12.2 = ;
COMPUTE COL5/D12.2 = ;
COMPUTE COL6/D12.2 = ;
COMPUTE COL7/D12.2 = ;
COMPUTE COL8/D12.2 = ;
FOR COUNTRY
'ENGLAND' LABEL Lab1 AS 'England' OVER
'W GERMANY' LABEL Lab2 AS 'W Germany' OVER
'FRANCE' LABEL Lab3 AS 'France' OVER
'JAPAN' LABEL Lab4 AS 'Japan' OVER
'ITALY' LABEL Lab5 AS 'Italy' OVER
RECAP Lab1(3)/D12.2 = Lab1(1) - Lab1(2); OVER
RECAP Lab2(5)/D12.2 = Lab2(1) - Lab2(2); OVER
""
ON TABLE SET HTMLCSS ON
ON TABLE SET PAGE NOLEAD
END
-RUNT
| |||||||||
|
| Member |
Tony, in your example how do I get RCOST for 'FRANCE' to show up in COL4 and DCOST to show up in COL6? What I want to do is condition the cell RCOST or DCOST would display in. Keep in mind that I'm new to all this and don't know the Focus language...yet. WebFOCUS 7.6.2 DB2, V5R4 Output: PDF | |||
|
| Expert |
Craig, Check out the documentation, it has most of what you would need to get started plus a bit more. You can use the search links at the top of this page or go to the main sie and search the technical documentation library  T
| |||||||||
|
| Member |
Tony, thanks for your help and advice. While this is a lot more work than I was lead to believe it's working. Still having a few issues but working through them. WebFOCUS 7.6.2 DB2, V5R4 Output: PDF | |||
|
| Member |
Can someone tell me how to keep my Recap statements from renumbering when I insert a line in the middle of an FML report? WebFOCUS 7.6.2 DB2, V5R4 Output: PDF | |||
|
| Virtuoso |
Graig How do you add that extra line? Do you type it into the source, or by using the GUI? It does not exactly work like in excel.
| |||||||
|
| Member |
I inserted it using GUI. I originally had my Recap statemtents grouped together. I've since moved each Recap right after the line it deals with. WebFOCUS 7.6.2 DB2, V5R4 Output: PDF | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |