Forum Discussion
sum column error
hi ,I need to sum all the values of one coloumn, but unfortunately it showing some syntax error? can someone have a look and let me know, how to fix this? Regards, vinod
Well we're getting closer. Try limiting to just 1 row using this formula:
Table =
TOPN(
1,
SELECTCOLUMNS(
FILTER(
Outbound,
Outbound[TER_FYTD_USD]
),
"New Column",
SUM(Outbound[TER_FYTD_USD])
)
)
Anonymous
this may not work in my other situations, I created a new coloumn using the below
SummarisedAccountsector = SELECTCOLUMNS(Inbound,"Sector",Inbound[AccountSector],"USD",Inbound[TER_FYTD_USD])
But whats happening is, i have only 3 account sector (Technology, Media & entertainment and Telecom)
my main issue is its not grouping the sector and their respetive aggregate sums
see the table table below
| Sector | USD |
| Technology | 400000 |
| Technology | 400000 |
| Technology | 400000 |
| media & entertainment | 400000 |
| media & entertainment | 400000 |
| media & entertainment | 400000 |
| telecom | 700000 |
| telecom | 700000 |
| telecom | 700000 |
Expected table
| Sector | USD |
| Technology | 400000 |
| media & entertainment | 5000000 |
| telecom | 700000 |