Skip to main content
Question

Excel Formula Not Read in Dynamic Report

  • October 30, 2019
  • 1 reply
  • 15 views
mukhtarg
Contributor
Forum|alt.badge.img+4

Hello,

I have a shapefile whose report I am trying to generate by pivoting. The result, I am able to get on different sheets. But the output is not calculating the formulas and hence I am not able to calculate summary for all the sheets. The template has only one sheet as a reference. It also has some formulas which calculate the summary.

 

When the reporting is done for the single file it reads the formula and generates the summary as well.

Attached herewith is the sample workbench and the template file to refer to. Any help in this regard is highly appreciated.

Thanks.

1 Attachments
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.

1 reply

M
Forum|alt.badge.img+2
  • markatsafe
  • October 30, 2019

@mukhtarg The name of the template sheet has to match the name of the output sheet. We should look at changing this so that the same template sheet can be used for different sheets.

You can create a separate Excel file for each shape file - each with the template. To do this use the Writer Dataset Fanout.

On your writer, select Fanout Dataset

and then set the fanout expression using the Text Editor, for example:

Dynamic_@Value(fme_feature_type).xlsx

this will give you a separate Excel file for each source shape file, with a single Sheet1 that matches your template. Example workspace (2019.2): excelreportexample.fmw

Community Stats

32,207
Posts
122,305
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.