Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
jim_chan
Specialist
Specialist

How to write an Sum expression?

Hi guys,

I would like to write an set analysis.

i have attached screenshot.

1) i have a straight table. i have a normal expression. sum(tree_population_points).

2) i am unable to sum up correctly. It should not show 7.

3) the total sum should be 18.

so, how can i get that sum??? group by? aggr???

Rgds

Jim

1 Solution

Accepted Solutions
Anil_Babu_Samineni

It will work direct way - May be this? sum(TOTAL tree_population_points)

Or change your expression like below

Capture.PNG

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

6 Replies
Anil_Babu_Samineni

It will work direct way - May be this? sum(TOTAL tree_population_points)

Or change your expression like below

Capture.PNG

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
tresesco
MVP
MVP

Use total mode 'Sum of rows' in the expression tab.

Capture.PNG

jim_chan
Specialist
Specialist
Author

Yes, it has given me the correct figure.

Can you show me how to write in a set analysis??

Rgds

Jim

jim_chan
Specialist
Specialist
Author

Yes, it has given me the correct figure.

Can you show me how to write in a set analysis??

Rgds

Jim

jim_chan
Specialist
Specialist
Author

i have tried with sum(TOTAL tree_population_points)

it gives me the wrong value - which is 7.

Anil_Babu_Samineni

For me, It's working with simple aggregation also. Would you share sample

Capture.PNG

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful