For example to write =MEAN($C$2:C@Value(_result)), where result is another attribute.
I tried with text, varchar attribute types when writing but didnt work.
Question
Excel formulas
There is a way to write in a attribute an excel formula?
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+21- Safer
Hi,
Using your formula I was able to write to both the new and old XLS writers, the attribute data type is string.
See https://www.dropbox.com/s/vvp0u615iatyp4u/Excel_formulas.fmw
Trying to do this with FME 2013 SP3 and Office 2003 without success. Also tried the demo workspace so either there was a regression or it only works with newer versions of Excel.
There is a naming convention for formulas explained here: http://fmepedia.safe.com/AnswersQuestionDetail?id=906a0000000csahAAA
- Participant
I realize this is an old question, but none of the existing replies helped me find the answer (thankfully it was documented).
You need to store the formula in a separate attribute named <AttributeName>.formula
So if you want a column named Total to be the result of a formula, create an attribute called Total.formula and populate it with your formula, e.g. =SUM(A2:B2)