Frequência acumulada

Ask for Help
1

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!

2

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
3

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.

image
image656×509 33.8 KB

Abraços!

4

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

1 Like
5

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!

6

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
7

That’s right!!

8

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