Apply and sum function difference

[Sophia Leblanc]

Hello everyone!
In the Data Manager, what is the difference between dragging the attribute on the APPLY area and choosing the sum function and typing it in the formula bar?

Thanks for your help!

[Sara]

Dragging an attribute onto the APPLY area in the query panel and choosing the function implies modifying the attribute itself replacing the original values with their output, which can only be a simple sum of the attribute dragged onto the Apply area. The query modifies the dataset’s structure. The APPLY query cannot be used to fill an empty attribute with the sum of another one’s values.

The function sum(), which can be typed in the formula bar, allows you also to group the results by a certain attribute’s values. You can use it to fill any attribute with any attribute’s sum, optionally grouped by another one’s values.

 

If you need more examples on how to use the apply panel and the sum function, follow the links to the technical documentation: Apply in the Query Panel and Sum function