Appian Community and Appian Academy are being upgraded. As a part of the upgrade, Appian Community is currently in read-only mode, and user registration is disabled until August 3. We apologize for any inconvenience this may cause, but a more secure, stable, and performant Community experience is coming soon!
The new Appian Community launches August 3, followed by Appian Academy on August 7. During the migration, Appian Community Edition, Appian Academy, Documentation, Certifications, Instructor-led Customer Training, Partner Sales Training & Accreditation, and Forum (for Appian Partners and Customers only) will remain available.
Team,
We have a requirement where we need to show difference of two rows in third row in paging grid. Like below , any suggestion?
Third column should show difference of row 2 minus 1st row of Column A.
Discussion posts and replies are publicly visible
What is the source of your data? Is it something static, or something with a variable number of rows? Whether this functionality is even possible at all, depends very strongly on these details which you haven't provided.
source of data is data subset and it will not change,
DataSubset is not the "source", but just how you have the local data stored. "Source" means where the data is originally coming from (unless it's just hardcoded static values in a local variable, in which case you should clarify).
This example form includes your use case
yes, though if it matters, this example is an editable grid (where the calculations are easy to do on a row-by-row and column-by-column basis), not a paging / read-only grid, where if we're going to do a similar thing, we need to assemble all the data up-front (or some other workaround).
True, but this depends on the number of rows needed. For two + 1 rows, that approach should be fine.
agreed - hence why my initial response was asking about the original source of the data, since that has a tremendous impact on what approach is taken here (or what would even work at all).
Source of data will be from database. 2 rows only per array. Second minus one...third row