Skip to main content
Solved

expand and contract rows and sum total at the bottom in excel

gisbradokla
Enthusiast
Forum|alt.badge.img+16
I am using statistics calculator to fill in the total number of features from a datasource.

 

  1. I want to expand and contract that list in excel dependent on non zero.
  2. I also want a grand total at the bottom to be just below the last row.

 

Do I need to get the max number of possible rows to use in a parameter?

 

Do I need to create a parameter to count those rows and make that parameter the location +1 of my grand total?

Best answer by fmelizard

Sounds like you could just route all the data features to your Excel output, and then route the summary feature coming out of the stats calculator there too. The stats summary feature will always come out last so will be the last row. You'd have to just name the "count" attribute to be whatever you named the column in Excel where you want that to go.

 

 

If the count was 0, then either the stats calculator won't output anything (because nothing came in) or you could use a Tester afterwards to throw out the record if it was 0. I believe the former.

 

 

Not sure what you meant by point #1 -- expand and contract the list.
View original
@gisbradokla
Did this help you find an answer to your question?
This post is closed to further activity.
It may be a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, 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.

2 replies

fmelizard
Contributor
Forum|alt.badge.img+17
  • fmelizardContributor
  • Contributor
  • Best Answer
  • October 31, 2015
Sounds like you could just route all the data features to your Excel output, and then route the summary feature coming out of the stats calculator there too. The stats summary feature will always come out last so will be the last row. You'd have to just name the "count" attribute to be whatever you named the column in Excel where you want that to go.

 

 

If the count was 0, then either the stats calculator won't output anything (because nothing came in) or you could use a Tester afterwards to throw out the record if it was 0. I believe the former.

 

 

Not sure what you meant by point #1 -- expand and contract the list.
takashi
Influencer
  • takashiInfluencer
  • October 31, 2015
Hi,

 

 

I think the grand total row from the Summary port of the StatisticsCalculator will be written at last naturally, in most cases.

 

However, it may not be guaranteed if you perform some operations for the data rows using some group-based (blocking) transformers in parallel with the StatisticsCalculator. Is there such a situation?

 

 

Takashi

Helpful Members This Week

Community Stats

31,139
Posts
118,062
Replies
38,770
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
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.