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?
Do you mean you want to do this in the database?
Or in a ‘table’ (or repeating group) on the page?
I think he mean in table.
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)
1 Like
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.
1 Like
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.
1 Like
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
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).
Finally after playing around I got it to work! Thank you for the great tip…
1 Like