May 28, 2009, 04:28 PM
Francis Mariani[SOLVED] EXL2K FORMULA and FML
Is there anybody else out there that wishes EXL2K FORMULA worked with FML?
This message has been edited. Last edited by: Francis Mariani, Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
May 28, 2009, 04:43 PM
DougI'm sure that I would rather have it working then not working when I do need it. And, I'm sure I will... Someday...
May 28, 2009, 04:49 PM
Francis MarianiThanks!
To get formulas to work I'm going to try using an Excel template, but I'm afraid I'll find out that won't work either!
I'm already getting frustrated as I haven't found any examples on how to use Excel templates - I've found just the syntax...
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
May 29, 2009, 03:57 AM
<JG>Francis You're quite correct the use of templates is not very well documented.
But they do work with FML output.
With regard adding formulas to FML output you can either use a template to do it all
or you could try doing it manually. Take a look at this post.
As mentioned it will insert an extra column which you would use a macro in the template to delete.
Excel Formula