Log in to AnswerLog in to Follow
UserImage.jpg
Bhagyashree Sawant
100Views
5Comments
Add  and Calculate Total Row in Table widget
Question
Reactive
Application Type
Reactive
Service Studio Version
11.10.12 (Build 39003)

I am using Table widget in Reactive Application. It shows estimates in each columns. I want to add a "Total Estimates" row, which will show the sum of each columns estimates. Also, If I filter the Table rows, then the "Total Estimates" row should also calculate the sum based on it.

Is there any way to calculate the sum columnwise and add that Total row in the Table? 


Regards,

Bhagyashree S

0
0
25 Feb 2021

Hi Bhaygyashree,

Could you please refer this link and try to implement the same?

Thanks & Kind Regards,

Sachin

0
0
25 Feb 2021

Please find attached the sample OML for your requirement. Kindly check and confirm, if you are looking for the same functionality. 

ShowTotal.oml

0
0
27 Feb 2021

Replying to Sachin Waghmare's comment on 27 Feb 2021 17:23:35

Also, find attached the sample excel file for data bootstrap into the entity for testing.

Sales.xlsx

0
0
27 Feb 2021

Replying to Sachin Waghmare's comment on 27 Feb 2021 17:23:35

Can you please share this sample but with an Aggregate instead of a SQL statement? I'm struggling with it.

0
0
05 Apr

Hi @Bhagyashree Sawant 

By your explanation, it seems you are fetching info from the database (aggregate) to populate info to the table, and applying what you want will increase complexity.

My advice is to use the fetch data from other sources, where you do the logic to return the list with the records and apply that output to the table, also each time you filter will refresh the DataAction and will recalculate the data as expected.

Hope this helps you.

If not, send the oml and give us more info in order we can analyze and help you better.

Regards

Gonçalo Almeida

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