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.
There is a way to write in a attribute an excel formula?
Page 1 / 1
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)
http://docs.safe.com/fme/html/FME_Desktop_Document...