Home/Questions/Q 6112
In Process
Bansari
Bansari

Bansari

View Profile
  • 1
Contributor
Asked: 2021-03-26T23:39:25+05:30

How to have an APEX item with arithmetic ability in APEX 19.1

  • 1

For example:
I’m having an item :P1_SALES
And I want to enter 1000+2000-1000
And it will give me 2,000 on the same item :P1_SALES

Note I’m using a plug-in(AutoNumeric) for my input format

question

    14 Answers

    1. Vinish

      Vinish

      View Profile
      Enlightened

      To do this, create a dynamic action on P1_SALES on Lose Focus event and create a true action to execute JavaScript code as follows:

      var c;
c = eval($v("P1_SALES"));
$s("P1_SALES", c);

      Save the changes and test.

      • 1
    2. Vinish

      Vinish

      View Profile
      Enlightened

      Your JS function should be as below:

      function fnc_calcTotal() {
var n_sales, n_cost, n_profit;
n_sales = parseFloat($v("P1_SALES"), 10) ? parseFloat($v("P1_SALES"), 10) : 0;
n_cost = parseFloat($v("P1_COST"), 10) ? parseFloat($v("P1_COST"), 10) : 0; 
n_profit = n_sales - n_cost; 
$s("P1_PROFIT", parseFloat(n_profit, 10));
}

      Now call the above function fnc_calcTotal from P1_sales and P1_cost on lose focus event.

      • 1
    3. Vinish

      Vinish

      View Profile
      Enlightened

      I have tested the above code and it is working completely fine.

      After creating that function in Function and Global Variable declare section and I am simply calling it using dynamic action on losing focus event by executing the JS code as below:

      fnc_calcTotal();
      • 1

    You must login to add an answer.