Your content is exactly what I am looking for. I do understand the basic definition of Iterator and Aggregation but a more detailed explanation would help. If SUM is incorrect when you apply any filter or criteria why would you ever use it? Why not just use SUMX all the time? Is SUM ever ok to use with a Pivot table? Too many questions...
I'm glad you found something that help you. SUM is very useful. It depends on the v situation to decide which function suit your situation. If we use SUMX for most cases and it is unnecessary, you will get slow performance as SUMX calculate each row. When you need aggregate level, or sum of a column, you use SUM instead of SUMX (i.e., you don't need to go throught each row). Also, when you use pivot table, the default is SUM. I hope it make senses. I'm more than happy to answer 😊
Would you please share exercise Excel files ? Would you Please elaborate what is the difference between Sum VS SUMX . Your example is informative but i need more support from your side to my better understanding
Here is the file: docs.google.com/spreadsheets/d/1vmT76CR9yW5GSlC-E_KcvTQejIJWFZKC/edit?usp=share_link&ouid=113026615372791522331&rtpof=true&sd=true In simple terms, one is an iterator function (SUMX), and the other one is not. The iterator function performs the evaluation/calculation at each row, whereas the other one is at the aggregated level.
Your content is exactly what I am looking for. I do understand the basic definition of Iterator and Aggregation but a more detailed explanation would help. If SUM is incorrect when you apply any filter or criteria why would you ever use it? Why not just use SUMX all the time? Is SUM ever ok to use with a Pivot table? Too many questions...
I'm glad you found something that help you. SUM is very useful. It depends on the v situation to decide which function suit your situation. If we use SUMX for most cases and it is unnecessary, you will get slow performance as SUMX calculate each row. When you need aggregate level, or sum of a column, you use SUM instead of SUMX (i.e., you don't need to go throught each row). Also, when you use pivot table, the default is SUM. I hope it make senses. I'm more than happy to answer 😊
Good demonstration with practical examples. Thanks.
Thank you, aatsw. I'm glad to hear that.
Could you please help me by indicating which are the scalar functions and the iteration functions. Thank you
SUMX is the iterator function.
Would you please share exercise Excel files ?
Would you Please elaborate what is the difference between Sum VS SUMX . Your example is informative but i need more support from your side to my better understanding
I'll find the file and upload it. What do you mean by you need more support?
@@bsmart2gether408 actually I wants to understand why and when sum and sumx results difference
Here is the file: docs.google.com/spreadsheets/d/1vmT76CR9yW5GSlC-E_KcvTQejIJWFZKC/edit?usp=share_link&ouid=113026615372791522331&rtpof=true&sd=true
In simple terms, one is an iterator function (SUMX), and the other one is not. The iterator function performs the evaluation/calculation at each row, whereas the other one is at the aggregated level.