14
Views
4
Comments
Solved
How to implement Total of SumAmount + TAX = Cumulative
Application Type
Traditional Web

Hi  Software Engineers,

I have many  attributes which is various prices columns in table records and I achieved SalesTotalAmount  Column with addition of new Attribute (adding various prices ).Can I  add as a user input (Tax) and Cumulative (dynamically calculate ) ? 

Dynamical place is SalesAmount and Cumulative. For that, I need to logic and how to implement  SalesAmount + Tax = Cumulative and next is the addition of previous cumulative .

For example:

SalesAmount          Tax              Cumulative 

16798                       1678             18476

30634                       5478              54588

27904                       2345             84837

Adding of various item is SaleAmount (Auto Calculate) and Cumulative is adding of SalesAmount and Tax . And want to desire in Cumulative with addition of previous Cumulative Amount . I want to share oml and check from there . 

Thanks.Hoping desire  result.

Hayasaka

TestForask.oml

Rank: #64
Solution

Hi Hayasaka,


In order to do that, you need to:

1. Create a variable that will hold the cumulative value to sum between line to line:


2. Add a new field to the table, in my example, I will also call it Cumulative:


3. After the query, you start adding the cumulative to each given row and assigning it to the field:


You can the OML in attachment for screen KisarazuListR2_10.


Hope it helps.


Regards,
João

TestForask.oml

Rank: #26721


Hi Joao Marques,

I achieved according to your way. Your Explanation was really perfect. Always Thanks.

Hayasaka

Rank: #285

Hi Hayasaka, 

Great to see that you got solution from Joao faster. I saw your question now. 

Sorry for being late.

Happy coding :) 

Rank: #26721

Hi Shweta Gedam, 

whatever I want to thank due to solve my different problems before.

I have to try more. 

Hayasaka