[Silk UI Web] Editable Table Calculations
Forge component by OutSystems R&D
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!


 

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


Solution

Hi João Ferreira

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

Regards,

Arun

EditableTableCalculation.oml

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


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

Solution

Hi João Ferreira

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

Regards,

Arun

EditableTableCalculation.oml

@Arun Rajput Thank you very much for your input.

This helped me a lot! 

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