Skip to Content (Press Enter)
UserImage.jpg
Martin De Winnaar
1956Views
4Comments
Sum Column Values
Discussion
How-to
Hi, I have a Units(Decimal) column in my entity and want to calculate total value of all Units records? I have tried to use "sum(units) for {table}" in adv. sql query but do not know what output to use. What is the correct way to do this? 

Any help would be appreciated. 

0
0
03 Mar 2014
Copy Link
2020-03-05 15-52-45
André Vieira
Staff
Hi Martin,

Check out this video in our online training. It covers the usage of Advanced Queries. You'll need to create a structure for the output of the query. In your case this structure should have 1 attribute of type decimal to hold the sum(units). In the Advanced query you'll need to provide proper SQL syntax to be executed. So you should have something like:

select SUM({Entity}.[Units]) from {Entity}


Cheers
0
0
03 Mar 2014
Copy Link
2018-06-25 16-44-26
Luis Eduardo Lopez Andrade

André Vieira wrote:

Hi Martin,

Check out this video in our online training. It covers the usage of Advanced Queries. You'll need to create a structure for the output of the query. In your case this structure should have 1 attribute of type decimal to hold the sum(units). In the Advanced query you'll need to provide proper SQL syntax to be executed. So you should have something like:

select SUM({Entity}.[Units]) from {Entity}


Cheers

It works great, thanks!


Note: Make sure the OutPut structure (the final structure of the result) has a Data Type (characteristics) Decimal. Example:


RoomService -> Table

Amount -> RoomService Table which I want to sum

BookingId-> Colum referencing to a Booking Table

@BookingId -> Is the value you pass to the query which you want to check

SELECT SUM({RoomService}.[Amount])
FROM {RoomService}
WHERE {RoomService}.[BookingId] = @BookingId

Hope it helps



0
0
18 Jun 2018
Copy Link
UserImage.jpg
Martin De Winnaar
Thank you, worked like a charm! I love a nice and easy explenation.
0
0
04 Mar 2014
Copy Link
UserImage.jpg
Patrick Rademakers

Link to the video seems broken

2
0
10 Jan 2017
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.