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.
Userlevel 4
+13
- Contributor
- 3701 replies
-
1 October 2013
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
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)
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.