Total Sales Column

[AsherDSimp_simp]

I have a table of Repair Orders, and each Repair Order has a Sale Column with the total Sales for the Repair Order. What would be the best way to get a Grand Total of all the sales? Should I create a separate table with a virtual column? My end goal is to display total sales on a dashboard along with some other metrics. Any help would be greatly appreciated. Thanks!

[Mike_A]

@AsherDSimp_simpson
Not exactly the same question - as mine was count and your is total, but you might want to scan this conversation thread. Might help?
Most efficient formula to count records

[Lynn]

Hi @AsherDSimp_simpson Have you had a look at the “Sales Report” sample App?

[Mike_A]

Nice idea @Lynn! Below might be the app she is speaking about. You can find these at Appsheet.com/support

https://www.appsheet.com/support?q=sales&hPP=10&idx=help&p=0&dFR[doc_type][0]=Apps&is_v=1

https://www.appsheet.com/samples/A-sales-reporting-app-with-Dashboard-and-Deck-views-of-sales-data-g...

[AsherDSimp_simp]

Thanks for the replies everyone!! I checked the “Sales Report” App, and although it is a neat and very useful app, I don’t know if it completely solves my problem. I need to total several hundred rows that have sales in one column. From what I can see in the app, values are totaled horizontally on a row by row basis, but not vertically. Here is an example of what I am looking for. Thanks again!!
2019-05-02_LI|624x432

[Steve]

Getting a sum of a column in a table is easy: SUM(Repair Orders[Sale]). But where to enter the expression, and where to display the result? Your idea to create a separate table with a virtual column to compute the sum is a good one, and would work well with your dashboard goal. That very same table and row could also be used for other roll-up metrics you want to calculate.

You didn’t need our help, you already knew the answer.

[AY2450]

HI Steve, Looking at something similar - most punters have said that Virtual columns slow down your App’s performance - I require a number (20+) of Total columns - should I do this with a standard column in a different table ?

[Steve]

I can’t say what you “should” do without more information.

Virtual columns are more likely to contribute to performance problems if any of the following are true:

• The table with the virtual column has thousands of rows or more.

• The virtual column’s App formula expression uses dereferences.

• The virtual column’s App formula expression uses a table-column reference.

• The virtual column’s App formula expression uses a query: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and/or SELECT().

Virtual columns are less likely to contribute to performance problems if the following are true:

• The table with the virtual column has few rows.

• The virtual column’s App formula expression only uses raw values and/or references to column values in the same row (i.e., doesn’t use dereferences or queries to gather or use values from other rows).

[AY2450]

Unfortunately it will be using de-references and I believe the column will get large (although the Totals will be based on a subset from an ID column in the table)