LinkedIn
Twitter
Hi,
I have a table called Equipment List with fields
Item Id - Key
Category,
Description
Current Location
Costs - VC - Related Cost details
I have a table Costs with fields
Item Id - Key
Purchase Date,
Cost
PO No
so the costs show as an inline view in the Equipment View for each Item
What I want to calculate is the total cost of all items.
I want to sum the Cost Column in the Costs table.
In Excel this would be =SUM(Tbl_Costs[Cost])
I have added a VC in the Equipment List Table
Sum([Costs][Cost]).
I want to show a list of
Item Id
Cost
and show the total costs for all these items
It seems very simple, just get the sum of a column but I canโt figure it out.
Any help much appreciated
This expression sums the related costs but there will always just be one cost per item.
I want to sum all item costs.
Cost could go in the Equipment List table but I want to show it as an inline view so thats why I created a costs table.
No, I want to sum up the column Costs in the Costs Table and display this, ideally with a list of all the Item Id associated with this total Cost.
Excel
I want to show $894
I have added a table to my Excel spreadsheet [Date] =today() and [Total Cost] : Sum(cost Column in Costs table) and added this table in with a view so I can now see total cost in App but would like to see this on same view with a list of all the item Idโs that make up this total cost.
I want to show this as a view in the App. It is a simple formula in Excel but cannot figure out how to do this in App. Just this one table with a Sum of the Costs column.
) which I am going to try.So this is what I have done.
-
Create a new tab in Excel
Summary Id - Key
Date
Total Owned Equipment Cost - has formula =SUM(Tbl_Costs[Cost]) -
Brought this table into App and created a Summary View.
-
Brought Item Description and Category into Costs table using VC
SELECT(Equipment List[Item Description],[Item Id] = [_THISROW].[Item Id])
-
Created a View of Costs table with
Item Id, Category, Description, Cost -
Created a Dashboard View showing Summary View and View created in step 4
My next task is to create an action and workflow to PDF and email this view but Iโm not sure this is possible. Director would like a monthly report to show this view to compare monthly costs.
I have another query on this .
Some Items are classed as High Value in the Equipment List Table. Yes or No.
I have brought this column into the costs table similar to the Description and Category above as a VC.
SELECT(Equipment List[High Value],[Item Id] = [_THISROW].[Item Id])
I want to create a slice of the Costs table for all high Value items but I get the error:
I have also tried bringing the Item Cost into the Equipment List table as a VC but it is then a list type and not a Price type thinking I could do the slice on the Equipment List instead
Any way to display this as ยฃ100.00?
I created another tab in my Excel spreadsheet to do the SUM and then imported this table into Appsheet and used in a Dashboard view.
