Skip to main content
Solved

Hi, Can please someone help me with calculating percentage change (X2-X1)/X1*100 for column Value when grouped by column Category. More specifically, how can get table 2 from table1.

  • September 12, 2023
  • 2 replies
  • 47 views

Forum|alt.badge.img

In table 2, the percentage change was calculated separately for each category of A, B, and C. I'm using FME2022.

 

Table 1

table1Table 2

table2

Best answer by ebygomm

You should be able to do this with adjacent attribute mapping in an AttributeCreator

 

image

View original
Did this help you find an answer to your question?

2 replies

ebygomm
Influencer
Forum|alt.badge.img+39
  • Influencer
  • Best Answer
  • September 12, 2023

You should be able to do this with adjacent attribute mapping in an AttributeCreator

 

image


Forum|alt.badge.img
  • Author
  • September 12, 2023

@ebygomm thank you so much. This is a great answer!


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