João Ferreira
Rank: #2252
59Views
4Comments
Solved
[Silk UI Web] Editable Table Calculations
Question
Beginner
Forge
Silk UI Web
Forge component by OutSystems R&D
106
Published on 09 Mar 2020
Application Type
Traditional Web

Hi there,


Sorry if this is a repetitive question, but I didn't found the answer about it.

I'm creating a Editable Table as show bellow




As you can see, the last column show be the product of quantity and unit price, and I also need to get the sum of all items total (Grand Total).


How can I do this 2 calculations? Also, the Grand Total is an expression?


Thank you in advance


Best regards and happy new year for all!


 

0
0
13 days ago
Copy link to comment
Arun Rajput
Rank: #13068
Solution

Hi João Ferreira, 

Please find this simple.oml I hope it will help you to solve your problem 

Regards,

Arun

See solution in context
EditableTableCalculation.oml

0
0
8 days ago
Copy link to comment
Amreen
Rank: #395
Solution

Hi João Ferreira,

If I am not wrong then you are multiplying  unit into quantity and show in total.

The attributes you had binded  to the expressions u can use that in total .

and regarding the grand total use can use a variable (grand total) and on save of the editable table  u can iterate the list and add the total  values.

Regards,

Amreen


0
0
10 days ago
Copy link to comment
João Ferreira
Rank: #2252

Hi @Amreen 


Thank you for your feedback.

Sorry for asking you this, but can you share a simple .oml where I can see how you do that?


Regards


João Ferreira

0
0
8 days ago
Copy link to comment
Arun Rajput
Rank: #13068
Solution

Hi João Ferreira, 

Please find this simple.oml I hope it will help you to solve your problem 

Regards,

Arun

EditableTableCalculation.oml

0
0
8 days ago
Copy link to comment
João Ferreira
Rank: #2252

@Arun Rajput Thank you very much for your input.

This helped me a lot! 

1
0
8 days ago
Copy link to comment