Appsheet Episode 14: How to sum up values in your table
HTML-код
- Опубликовано: 13 сен 2024
- Hi, thanks for watching this video about Google Appsheet!
In this video we’ll walk you through:
- Sum up multiple numbers
- Use AND( ) expression for multiple conditions
Formula used in this tutorial :
SUM(Employee Data[Salary])
SUM(SELECT(Employee Data[Salary],[JOB]="PMO"))
SUM(SELECT(Employee Data[Salary],AND([JOB]="PMO",[COUNTRY]="United States")))
______
ABOUT THIS CHANNEL
My channel is about Technology and General videos. We cover lots of cool stuff such as Appsheet tutorial, highlights and day to day stuff.
Don’t forget to subscribe!
Thank you so much for your great videos. I am new on Appsheet. I am watching all videos from the beginning. it's very useful. It' just as short and as complete as needed.
I just had some troubles with this SUM(SELECT(Employee Data[Salary],[JOB]="PMO")) formula. I used the Data Explore to select the right Columns in my app and it gives me something like that: SUM(SELECT(Employee Data[Salary],Employee Data[JOB]="PMO")) with the error message: "Cannot compare List with Text". It made me crazy. I finally understood that I had repeated the table twice and this is not a good idea. deleting the 2nd "Employee Data" was enough to solve the problem 😅
hi .ı am from turkiye. ı learned appsheet from of you. thanks you so much
Greetings my brother from Turkiye! Thank you for the support!
hello there , im a newbie in appsheet. and im a bit confuse with sum expression and virtual column also. Just make sure : I need a virtual column to calculate totals with a sum expression, so if I have created a total column in Google Sheet, that column doesn't work? so that the total column is created later when in the appsheet ? Thanks before
Could you please guide me on how to sum based on the month?
For example, I want to some all the values if they are of October.
same, following
Thanks for the video! How should the expression in the Security filter look like? This is what I am really struggling with.
I can try to do a video regarding security filter. Hang in there!
Very useful thank you.
Thank you!
Hello brother, thank you very much for your wonderful explanations
Brother, I want to know how I can add a button to display daily records, daily movements, and so on
Can you give us an explanation please, thank you
Excelente. Thank you for sharing
Always a pleasure Mr Marcel. I hope my videos are helpful for you 😎
I love you
Your love is well received and my love back to you!
so, everytime i want to count my total data , i need to make a virtual column first ?
it depends actually..both column types can still work..if you use virtual column you can get the latest/updated value without saving the data. If you use the "physical" column then you need to ensure data is saved then the calculation will happen. There's no right or wrong here..just preference
hope it helps ;)
Thanks for the tips bro. Ive been watching most of your informative and easy to follow videos. Thanks. Just to ask, can i use SUM let say to Calculate "total visit for each unique ID person" using this method? or is it better i put an extra column in the Google Sheet files for this kind of data.
Yes, absolutely! you can use an expression to unique calculate according to each person. In fact i just did one simple project that has this characteristics.. i will make a video on it soon!
ok, wow
Hello Aris. The video was very helpful. I came up at a difficult point although. I have created a virtual column to sum the column SalesValue for a table Sales with a condition only for the value "Kalathas" that belongs to the enum (list) column Salesman.
I tried this:
=sum(select(Sales[SalesValue], IN("Kalathas", Sales[Salesman])))
but it results with the overall sum.
Please advice!
I will look into this and try to replicate the scenario and make it into a video for your reference and everyone else. This is a great case!
Did you make a video solving this ? If yes, can you pass the link to me.. tqvm
I have same problem..
if Salary sheet updated, is it possible to automatically update sum of salary?? is yes please describe how.
Thanks Aris. Excellent tutorial
you're most welcome..i'm glad you liked it
Thank You Mr Aris Azhar, Great effort, you done as what you said.
Pleasure is all mine! Hope this helps. Do spread the word on this channel so that many would know ...Thank you!
Sure @@aris_azhar , This channel will reach needy soon. You are unique in the way of presentation. Also crystal clear explanation.
Video duration is not so bore to watch.
Keep it up all.
Congratulations 🎉
@@ganeshramu5083 Kind words Mr Ganesh Ramu..thank you! yes, i prefer to keep things as simple as it should be..i will do better from time to time! TQ again for your support..this made my day
Thanks a lot for this wonderful video
@@قطرالندى-ج8ن Im glad this is wonderful for you, do share this to others too!...Pleasure is all mine brother
Hi, how can you sum only the selected rows from a Enumlist?
Hi, is it possible to kindly see an example of an App with two skill descriptors (or two products for example ) to which the user assigns a score and the App calculates the average by assigning a vote?
Hello sir. Sounds possible to do, but perhaps let's discuss on the details further yes? Lookinf forward to hear from you soon!
@@aris_azhar Thanks for the answer, I would like to try to make an App that calculates the grade of a math test. to simplify: there are 4 descriptors (I can send you the image of the ggole sheet if you give me your email to see) as in the first column of the table) and sub-descriptors to which a score is assigned. The user clicks on a button with the score assigned to each sub-descriptor and the app should calculate the sum assigning the score. See you soon.
I saw your expression for SUM and it is very hard coded. What if I have all countries from the whole world (~195) and I want to make SUM for each of them. How to make this expression more dynamic?
hello! yes it is hardcoded since i want to keep it at a very basic level. Anyways, to make it more dynamic we'll need some data. Mind sharing more info on your case? it's definitely doable
Thank you very much, very good tutorial, two questions, 1.- how is the view of compnay? 2.- if you wanted to present them without having to enter a detail, ie the 3 data on a single screen for use in a dashboard, how would the view? as well as condition it by dates, in my case I have several transactions per day and I want to get the totals by category, Thanks in advance for your help
Hello! Thank you for the support..anyways i try to answer your questions:
1) For view is subjective to your case. You may want to play around with Slices..i did a video on "Data Slice" and you can try to set your own view
2) for this case i would suggest you to use the "Card" or "Detail" view and add the relevant columns. But i will add a new video on this so it's easier for you to understand.
3) for dates and by category can use data slices or group it in your view. Will add that in the upcoming video
@@aris_azharhi, how are you ? please how to use SUM function with multiple columns for example January 10$ , February 10$ , March 10$ etc... depending on a city or year.
what expression should i use to filter salary by month? lets say PMO for Jan 2022, Feb 2022 and so on.. thanks in advance
You can use charts instead; it will segregate the info for you as how you've wanted. Other than that, you can use Data slice (can refer to my other video on data slice) and filter it for PMO. Create a new view using that slice and group it by Month.
Let me know if this works for you. Apologies for my late response, been away on an adventure lately
It will take action if the value changes, if the value does not change it will remain the same
Brother, how can i get 4 columns total ??
Bg, kl mw sumif nya muncul di header sesuai dengan filter kita gmna ya?
Bg, bisa bagi butiran lebih lanjut? Saya boleh coba untuk buat tutorial jika bisa
hey there, i have been using this expression to get the total value of the billed items in invoice app...SUM ( SELECT (Invoice List of Items[Total Price], [Invoice ID] = [_THISROW].[Invoice ID])) ........ but it always showing 0 no values where generated...plz do help me..
I will see if i can make video on this very very soon! hang in there!
@@aris_azharDid you make a video solving this? If yes, can you pass the link?
Hello, how can I make the application formula write the user's name or e-mail in another column if the value in one column changes?
You can make use of USEREMAIL() expression in a separate column when that condition triggers. Either thru Automation (robot) or based on input