Pessoal, alguém sabe como é possível fazer uma frequência acumulada com incremento? Quero pegar o valor da linha anterior e somá-lo com o incremento que escolher (+1, por exemplo). Abraços!

Hi Samuel, welcome to the community!

I assume you’re adding rows either with a form or an add row action. Let’s call your incremental column “Number”.

You will have a “Next Number” column that is a math column with the formula Number + 1. Point the Number part to the Number column.

When you use an add row action or a form, use a screen value (if you’re writing new rows from a details view), point to the “Next Number” screen value and write to the Number column for the new row.

If you’re adding from a list view, you may want to create a rollup column instead to take the max number from the “Number” column, then use the same “Next Number” approach above.

3 Likes

Olá, obrigado pela rápida resposta. Com a imagem abaixo, gostaria que ocorresse a soma entre a linha anteior (5) “ORGANIZAÇÃO” e o incremento escolhido (por exemplo, 2), resultasse em 7 como o dado da primeira linha da mesma tabela.

Ao invés de apenas utilizar o incremento 2 isolado, gostaria que ele fosse somado com o resultado da linha anterior.

Abraços!

@Lucas_Pires or any Portuguese/Spanish speakers, can you help with this case? I’m not entirely sure about the translation.

1 Like

The “ORGANIZATION” column receives data from an increment via a button. For example, in the last line of the “ORGANIZATION” column in the image above, the data is 5. In the next line, in a form, I will enter a specific increment (2, for example). I would like the data on this line to be 7 (5 from the previous line + 2 from the new increment) and not 2 as it is being registered (only the increment is registered). Thanks in advance!

So what you enter in the form is the increment, and then you want to retrieve the value from the previous row to have a final sum between the two?

1 Like

That’s right!!

Then what I would do is:

• Add a rowID column if you haven’t done so.
• Add a “previous rowID column”.
• Use the current rowID’s column (if you add it through the details view) to set to the new row’s previous rowID column in an add row action/form environment.
• If you use a list view, retrieve the last rowID through a single value column, then do the same thing as above.
• Through the previous rowID column, make a relation and a lookup to retrieve the previous row’s “number”.
• Use a math column to sum the number retrieve above with the increment number you add through the form.
3 Likes