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.
I never worked on FML but I have a request for a report which i feel like can be done using FML. I have a doubt on I am looking for some suggestions.
Layout
ABC - Text CurM PrvM CurQ PrvQ xyz - Text MetricField1 1234 765 6787 543 - Number MetricField2 2.1% 1.1% ........ - Percentage values DEF - Text asd - Text MetricField3 657 345 335 435 - Number values Metric4 0.1% 8% ............ - Percentage values
Using the regular table request we can define custom field format like Field/Myformat = If FIELD EQ 'ghj' THEN 'D12.2' ELSE 'I11 ; something like this. How I can achieve this for the above layout?
I appreciate any suggestions in achieving the above.
Thanks, Rao.This message has been edited. Last edited by: FP Mod Chuck,
WebFOCUS - ver8201 [ReportingServers: Windows 64bit; Client: tomcat and IIS on windows 2012 AppStudio
Posts: 104 | Location: Indianapolis | Registered: November 08, 2007
FML looks like the answer to the formatting of the report but I'm not clear on your field formatting example as to which metrics you want to apply it to.
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats
Posts: 2128 | Location: Customer Support | Registered: April 12, 2005