Log in to AnswerLog in to Follow
Bhagyashree Sawant
25Views
4Comments
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
on 25th Feb

Hi Bhaygyashree,

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

Thanks & Kind Regards,

Sachin

0
0
on 25th Feb

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
on 27th Feb

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
on 27th Feb

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
on 26th Feb
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.