help to create rule to calculate data based on the previous iteration

Paola Cotrina

Certified Associate Developer

6 hours ago

I have this array {100, 50, 20,50,10} and a variable x = 600, I need help to create a rule that creates an array with the results that must be calculated in this way:

The first value of the array must be subtracted with the variable x, the result must be subtracted with the second value of the array, the previous result must be subtracted with the third position and so on. The results must be stored in an array.

At the moment I have this code but it does not work correctly



a!localVariables(
 local!regularizaciones: {100, 50, 20,50,10},
 local!initialValue: 600,


 local!resultArray: {local!initialValue},

 a!forEach(
 items: a!forEach(
 items: local!array,
 expression: fv!item
 ),
 expression: a!localVariables(
 local!currentValue: fv!item,
 local!lastResult: index(local!resultArray, length(local!resultArray)),
 local!newResult: local!lastResult - local!currentValue,
 local!resultArray: append(local!resultArray, local!newResult)
 )
 ),


 local!resultArray
 
)

I appreciate any help

Discussion posts and replies are publicly visible

0 Yogi Patel

Certified Associate Developer

4 hours ago

You can use the reduce function. See the following sample code:

a!localVariables(
  local!regularizaciones: { 100, 50, 20, 50, 10 },
  local!initialValue: 600,
  reduce(
    fn!sum,
    local!regularizaciones[1] - local!initialValue,
    ldrop(local!regularizaciones, 1) * ( - 1)
  )
)

0 venkat Avuluri

Certified Senior Developer

4 hours ago

Hello, You should have mentioned how you wanted your output .have a look into the code the output of this code looks like {500,450,430,380,370}

a!localVariables(
  local!regularizaciones: {100, 50, 20,50,10},
  local!initialValue: 600,
a!forEach(
  items: local!regularizaciones,
  expression: a!localVariables(
    local!subtractedarray:if(
      fv!index=1,
      local!initialValue-fv!item,
      local!initialValue-sum(index(local!regularizaciones,(enumerate(fv!index)+1),null))
    ),
    {local!subtractedarray}
  )
)

)