Skip to main content
Solved

how to use current calculated feature in the next step.


aska
Contributor
Forum|alt.badge.img
  • Contributor

I have this equation in Excel:

=A2-($A$2-$G$2)*B4/SUM($B$4:$F$4)

this A2 and B4 has to change every row. so that the value I just got from the current row calculation needs to be used in the next step.

9.83,8.82,7.56,6.41,5.41,5

minus

0,1.01,1.26,1.14,0.99,0.4

it starts with 9.83-0, then 9.83-1.01, then the result which is 8.81-1.26 and so on.

how can I write this equation? or how can I get the result of previous row calculation in the current row?

Best answer by nielsgerrits

aska wrote:

AttributeCreator has the same functionalities like AttributeManager. I have tried to use CurrentAttribute function, however, it returns 0. May you please show me how the arithmatic equation whould look like? or is there a way to get the value of CurrentAttribute(feature[-1])?

 

 

Here you go.

 

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

7 replies

nielsgerrits
VIP
Forum|alt.badge.img+54

You can do this using an AttributeCreator, make sure to enable adjacent feature handling.


aska
Contributor
Forum|alt.badge.img
  • Author
  • Contributor
  • January 13, 2023
nielsgerrits wrote:

You can do this using an AttributeCreator, make sure to enable adjacent feature handling.

AttributeCreator has the same functionalities like AttributeManager. I have tried to use CurrentAttribute function, however, it returns 0. May you please show me how the arithmatic equation whould look like? or is there a way to get the value of CurrentAttribute(feature[-1])?

 

 


nielsgerrits
VIP
Forum|alt.badge.img+54
aska wrote:

AttributeCreator has the same functionalities like AttributeManager. I have tried to use CurrentAttribute function, however, it returns 0. May you please show me how the arithmatic equation whould look like? or is there a way to get the value of CurrentAttribute(feature[-1])?

 

 

If you add some example data it is easier to explain, so much possibilities.


aska
Contributor
Forum|alt.badge.img
  • Author
  • Contributor
  • January 13, 2023
aska wrote:

AttributeCreator has the same functionalities like AttributeManager. I have tried to use CurrentAttribute function, however, it returns 0. May you please show me how the arithmatic equation whould look like? or is there a way to get the value of CurrentAttribute(feature[-1])?

 

 

the data is column1 + value 9.83

ideal output is column2

column1 Column2

0 -> 9.83-0 ~ 9.83

,1.01-> 9.83-1.01 ~ 8.82

,1.26 -> 8.82-1.26 ~ 7.56

,1.14 -> 7.56-1.14 ~ 6.41

,0.99 -> 6.41-0.99 ~ 5.41

,0.4 -> 5.41-0.4 ~ 5.00

 

 


nielsgerrits
VIP
Forum|alt.badge.img+54
  • Best Answer
  • January 13, 2023
aska wrote:

AttributeCreator has the same functionalities like AttributeManager. I have tried to use CurrentAttribute function, however, it returns 0. May you please show me how the arithmatic equation whould look like? or is there a way to get the value of CurrentAttribute(feature[-1])?

 

 

Here you go.

 


aska
Contributor
Forum|alt.badge.img
  • Author
  • Contributor
  • January 13, 2023
aska wrote:

AttributeCreator has the same functionalities like AttributeManager. I have tried to use CurrentAttribute function, however, it returns 0. May you please show me how the arithmatic equation whould look like? or is there a way to get the value of CurrentAttribute(feature[-1])?

 

 

thank you @nielsgerrits​ 

I imagine to use the feature-1 of an attribute, you must have defined the attribute a step ahead. good learning. thank you


nielsgerrits
VIP
Forum|alt.badge.img+54
aska wrote:

AttributeCreator has the same functionalities like AttributeManager. I have tried to use CurrentAttribute function, however, it returns 0. May you please show me how the arithmatic equation whould look like? or is there a way to get the value of CurrentAttribute(feature[-1])?

 

 

Cheers :)


Reply


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