Is there anyway to show a table where the last line of the table has cells that are a sum of the values above?
I know that AppSheet treats a table like a proper database, where each row is a new entry that should follow the same parameters as all other rows in that table.
But maybe there is a work around? Like a virtual row instead of a virtual column, this virtual row being in bold or something and calculating based on above rows?
@Aleksi_Alkio of course itโs doableโฆ But why, oh why, would anyone want to do that over following good designโฆ Cause it basically makes you have to fight appsheet from here on outโฆ Now select functions have to have exclusions, group totals breakโฆ I mean ugh Everytime poor Rogerio
posts in the form about something not working itโs going to be because of this โfalseโ recordโฆ
Nope, what it really comes down to is your actually have a higher order of data table that you need to includeโฆ
i.e. if youโre talking all of the companies equipment on that table, imagine if you had 10 companiesโฆ
Your would have a table of companies, then all of their related equipment in your current tableโฆ So all you need is a parent tableโฆ Thatโs where that single summation line would resideโฆ
@Grant_Stead but how to show the sums together with the values? Letโs say I have a list of Invoices for a single client. I want to know the total value of those invoices, as well as the summed liquid value of those invoices (minus taxes) and the sum of the clientโs already made paymentsโฆ
Email address?
@Aleksi_Alkio rogerpenna@gmail.com Translate
App sharedโฆ take a copy and examine it.
Anyway, my two cents when it comes to appsheet is that anytime you fight the natural structure that appsheet itโs banking on you having, then it creates 10x more work down the roadโฆ But I agree, I would be remiss to exclude that you CAN do pretty quick whatever you want Iโm appsheetโฆ
Wellโฆ sometimes customer can request something different and if you donโt want to loose, you need to find a wayโฆ even if itโs something different. I always try to do in a โrightโ way, but sometimes itโs not possible.
@Rogerio_Penna Well, I would be looking in the app at the Client, and see the totals, and also see the value of each invoice as an inline table viewโฆ In a workflow report, I could see the total summary, and then also a list of each invoiceโฆ
I got lost here โI would be looking in the app at the Client, and see the totals, and also see the value of each invoice as an inline table viewโ
See the totals? Where? Having a column for the sum of the values?
I would be looking at the detail view of the client, which has columns that sum the totalsโฆ Then in the detail view you would also see the inline refrows of that clients associated invoices, at which point you could click into and see further detailsโฆ
What your talking about is a very classic relationship and space handles it pretty wellโฆ
@Aleksi_Alkio How you did that Aleksi? Translate
Workaround #462
@Aleksi_Alkio Teach me, master! Translate
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |