Data table calculation

dennisv24 · 2024-09-18T12:26:03.741Z

Hi,

For a data table I want to create a column where it calculates the current row count minus the previous row count.

So let’s say the first row shows the count 120 and the second row 130, the difference column I want to show 10…

Does someone have a idea of how the dynamic data would look like in a text field?

adamhholmes · 2024-09-18T12:33:30.475Z

Do you mean you want to do this in the database?

Or in a ‘table’ (or repeating group) on the page?

Baloshi69 · 2024-09-18T12:43:36.025Z

I think he mean in table.

adamhholmes · 2024-09-18T12:46:20.984Z

In that case the expression will be:

current row's thing's count - (Table's list of things: item# (current cell index - 1)'s count)

Baloshi69 · 2024-09-18T12:47:56.195Z

inside table let say the field is A in Database, which store the count.

in table text element user below condition

Repeating Group ' item A - Repeating Group 'item current cell index + 1 'A

so if current cell have 130 and previous cell have 120 = > it gonna show 10.

If you still stuck, ping me, i would love to understand you situation and walk you through.

Baloshi69 · 2024-09-18T12:49:22.270Z

Yah, we both are correct, but not depend on , either he want to minus from previous cell , or next cell

but i think you approach is better.

dennisv24 · 2024-09-18T12:52:12.116Z

I did see some forums talking about this solution…

The only thing is when I follow the steps I can’t go further than this: "Current row’s thing’s Number - " When adding the () the options are elements
Screenshot 2024-09-18 at 14.51.54

adamhholmes · 2024-09-18T12:54:23.305Z

You don’t type “(” just use the expression builder - the parenthesis will be added automatically, assuming you have the parentheses feature enabled (which I think you’ll need to do this).

dennisv24 · 2024-09-18T14:15:50.942Z

Finally after playing around I got it to work! Thank you for the great tip…