Skip to Content (Press Enter)
UserImage.jpg
Robbie Chandra
64Views
5Comments
Solved
counting all serviceprice record to grandtotal
Question

how can i count all the records from serviceprice to grand total

Bookingsrobbyedit.oml
0
0
13 Oct 2020
Copy Link
2025-01-17 13-21-13
Clarisse Carneiro
Solution

Robbie Chandra wrote:

Clarisse Carneiro wrote:


Hi Robbie,

At the moment you have two aggregates: one to display the data of the booking on your popup and the other one to display the data of the room service.

A quick fix is:

     1. Add another aggregate in your preparation. 

     2. In that aggregate do the Sum function aggregating on all the room services price from that bookingId.

     3. Use that aggregate output on the Grand Total Expression + GetBookings(...).Total.

As a performance best practice you should use the SQL tool instead of the aggregate but if you are just starting don't over complicate :)

I hope it helped. If you have any doubt feel free to ask :)

Best regards,

Clarisse

 There are other solutions, like @Zhou Shuai mentioned, counting it on the preparation - using a for each to go through the GetRoomServicesById List and save the data of that counting/sum on a local variable... then you use the local variable on the expression.

See what best fits your case :)

Best regards,

Clarisse

 

 

 How can i use sum in expression? 

 Hi Robbie,


If you use the aggregate scenario:

  1. Create the aggregate, lets name it GetRoomServicesByIdSum (for example)
  2. Do the Sum on the SumServ Column (I think it is on this one that you have the total price per service)
  3. On the Grand Total expression use the aggregate, it should be something like this:
  4. GetRoomServicesByIdSum.List.Current.ServicePriceSum + GetBookingsById.List.Current.Total

If you use the Count option:

  1. Do a for each on the preparation for the record list GetRoomServicesById.List
  2. Create a local variable (example: TotalServices)
  3. On the flow of the preparation set an assign for the TotalServices
  4. In the assign the Total Services will be equal to 
  5. TotalServices = TotalServices + GetRoomServicesById.List.Current.SumServ
  6. With this you are iterating through your RoomServices types, summing each one and storing it on the variable. 
  7. Just use the variable on the Grand total expression:
  8. TotalServices + GetBookingsById.List.Current.Total

 

Here is a picture with both solutions in place, just pick one:



Hope it helped,

Clarisse

See solution in context
0
0
13 Oct 2020
Copy Link
UserImage.jpg
Robbie Chandra

Clarisse Carneiro wrote:

Robbie Chandra wrote:

Clarisse Carneiro wrote:


Hi Robbie,

At the moment you have two aggregates: one to display the data of the booking on your popup and the other one to display the data of the room service.

A quick fix is:

     1. Add another aggregate in your preparation. 

     2. In that aggregate do the Sum function aggregating on all the room services price from that bookingId.

     3. Use that aggregate output on the Grand Total Expression + GetBookings(...).Total.

As a performance best practice you should use the SQL tool instead of the aggregate but if you are just starting don't over complicate :)

I hope it helped. If you have any doubt feel free to ask :)

Best regards,

Clarisse

 There are other solutions, like @Zhou Shuai mentioned, counting it on the preparation - using a for each to go through the GetRoomServicesById List and save the data of that counting/sum on a local variable... then you use the local variable on the expression.

See what best fits your case :)

Best regards,

Clarisse

 

 

 How can i use sum in expression? 

 Hi Robbie,


If you use the aggregate scenario:

  1. Create the aggregate, lets name it GetRoomServicesByIdSum (for example)
  2. Do the Sum on the SumServ Column (I think it is on this one that you have the total price per service)
  3. On the Grand Total expression use the aggregate, it should be something like this:
  4. GetRoomServicesByIdSum.List.Current.ServicePriceSum + GetBookingsById.List.Current.Total

If you use the Count option:

  1. Do a for each on the preparation for the record list GetRoomServicesById.List
  2. Create a local variable (example: TotalServices)
  3. On the flow of the preparation set an assign for the TotalServices
  4. In the assign the Total Services will be equal to 
  5. TotalServices = TotalServices + GetRoomServicesById.List.Current.SumServ
  6. With this you are iterating through your RoomServices types, summing each one and storing it on the variable. 
  7. Just use the variable on the Grand total expression:
  8. TotalServices + GetBookingsById.List.Current.Total

 

Here is a picture with both solutions in place, just pick one:



Hope it helped,

Clarisse

 Thanks.

its now all service price record  has counted

 

1
0
13 Oct 2020
Copy Link
2021-04-07 10-08-47
Zhou Shuai

Hi Robbie,

   You could count it in preparation then show on screen.

Regards,

Zhou Shuai

0
0
13 Oct 2020
Copy Link
UserImage.jpg
Robbie Chandra

Zhou Shuai wrote:

Hi Robbie,

   You could count it in preparation then show on screen.

Regards,

Zhou Shuai

 

 How to count all records in column? 

0
0
13 Oct 2020
Copy Link
2025-01-17 13-21-13
Clarisse Carneiro

Hi Robbie,

At the moment you have two aggregates: one to display the data of the booking on your popup and the other one to display the data of the room service.

A quick fix is:

     1. Add another aggregate in your preparation. 

     2. In that aggregate do the Sum function aggregating on all the room services price from that bookingId.

     3. Use that aggregate output on the Grand Total Expression + GetBookings(...).Total.

As a performance best practice you should use the SQL tool instead of the aggregate but if you are just starting don't over complicate :)

I hope it helped. If you have any doubt feel free to ask :)

Best regards,

Clarisse

0
0
13 Oct 2020
Copy Link
2025-01-17 13-21-13
Clarisse Carneiro


Hi Robbie,

At the moment you have two aggregates: one to display the data of the booking on your popup and the other one to display the data of the room service.

A quick fix is:

     1. Add another aggregate in your preparation. 

     2. In that aggregate do the Sum function aggregating on all the room services price from that bookingId.

     3. Use that aggregate output on the Grand Total Expression + GetBookings(...).Total.

As a performance best practice you should use the SQL tool instead of the aggregate but if you are just starting don't over complicate :)

I hope it helped. If you have any doubt feel free to ask :)

Best regards,

Clarisse

 There are other solutions, like @Zhou Shuai mentioned, counting it on the preparation - using a for each to go through the GetRoomServicesById List and save the data of that counting/sum on a local variable... then you use the local variable on the expression.

See what best fits your case :)

Best regards,

Clarisse

 

0
0
13 Oct 2020
Copy Link
UserImage.jpg
Sarah Javed

why I am unable to download  this oml file

0
0
26 Jul 2021
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.