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 Kapoor

    Vinish Kapoor

    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 Kapoor

    Vinish Kapoor

    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 Kapoor

    Vinish Kapoor

    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.