Hey, Dev!
Are you looking for a forum full of active developers to help you?
So if you want to:
➡️ Get answers for your development issues
➡️ Help others
➡️ Write an article
➡️ Get rewarded for your active participation
Then this place is just for you and it is 100% FREE.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
How to have an APEX item with arithmetic ability in APEX 19.1
Bansari
Please help me out to close this as it is getting crucial for my project. Thanks in advance for all your extra effort.
Please help me out to close this as it is getting crucial for my project.
Thanks in advance for all your extra effort.
See lessHow to have an APEX item with arithmetic ability in APEX 19.1
Bansari
Yes, you are right, I tried but it’s not calculating values. Is there any other way? Format mask also not supporting. And tried plug-ins too, but those ones are not allowing me to enter numbers like 1000-500.
Yes, you are right, I tried but it’s not calculating values.
See lessIs there any other way?
Format mask also not supporting.
And tried plug-ins too, but those ones are not allowing me to enter numbers like 1000-500.
How to have an APEX item with arithmetic ability in APEX 19.1
Bansari
Ok, I can double check my function and fields, But please let me know how to achieve format within those numbers as it is equal important for me with this arithmetic ability. I have tried “ Number(this.value).toFixed(2).replace(/(\d)(?=(\d{3})+(?!\d))/g, '$1,')" within function.
Ok, I can double check my function and fields,
See lessBut please let me know how to achieve format within those numbers as it is equal important for me with this arithmetic ability.
I have tried “ Number(this.value).toFixed(2).replace(/(\d)(?=(\d{3})+(?!\d))/g, '$1,')"
within function.
How to have an APEX item with arithmetic ability in APEX 19.1
Bansari
I tried below function function fnc_calcTotal() { var n_sales, n_cost, n_profit; n_sales = eval($v("P11_SALES")); $s("P11_SALES", n_sales); n_cost = eval($v("P11_COST")); $s("P11_COST", n_cost); n_sales = parseFloat($v("P11_SALES"), 10) ? parseFloat($v("P11_SALES"), 10) : 0; n_cost = parseFloat($v("Read more
I tried below function
function fnc_calcTotal() {
var n_sales, n_cost, n_profit;
n_sales = eval($v("P11_SALES"));
$s("P11_SALES", n_sales);
n_cost = eval($v("P11_COST"));
$s("P11_COST", n_cost);
n_sales = parseFloat($v("P11_SALES"), 10) ? parseFloat($v("P11_SALES"), 10) : 0;
n_cost = parseFloat($v("P11_COST"), 10) ? parseFloat($v("P11_COST"), 10) : 0;
n_profit = n_sales - n_cost;
$s("P11_PROFIT", parseFloat(n_profit, 10));
}
Removed custom attribute and eval function from both P11_SALES and P11_COST as you mentioned
But, it is not giving me P11_PROFIT calculated and, Where can I add format part as I have to implement it?
Thanks
See lessHow to have an APEX item with arithmetic ability in APEX 19.1
Bansari
I guess because I'm using onfocusout="this.value=Number(this.value).toFixed(2).replace(/(\d)(?=(\d{3})+(?!\d))/g, '$1,')" as well on both the fields and then I do have 2 JS code implementing in dynamic action for both items.
I guess because I'm using
See lessonfocusout="this.value=Number(this.value).toFixed(2).replace(/(\d)(?=(\d{3})+(?!\d))/g, '$1,')"
as well on both the fields
and then I do have 2 JS code implementing in dynamic action for both items.
How to have an APEX item with arithmetic ability in APEX 19.1
Bansari
Yes I do have exact same function. Just difference is, I do have input type 1000+2000 and function in same dynamic action.
Yes I do have exact same function.
See lessJust difference is, I do have input type 1000+2000 and function in same dynamic action.
How to have an APEX item with arithmetic ability in APEX 19.1
Bansari
Hello, thanks, for the solution. Now everything is working step by step. I'm right now on the last step of fulfilling the requirement. I did apply both above step and using this now the last part is addition of 2 fields with the same behavior I mentioned above. I used JavaScript solution of yours' (Read more
Hello,
thanks, for the solution.
Now everything is working step by step.
I'm right now on the last step of fulfilling the requirement.
I did apply both above step and using this now the last part is addition of 2 fields with the same behavior I mentioned above.
I used JavaScript solution of yours' (https://www.foxinfotech.in/2020/02/oracle-apex-calculate-field-values-using-javascript.html)
But now all three fields working differently:
1. P1_SALES, P1_COST (TEXTFIELD with 2 steps mentioned above)
2. P1_PROFIT (TEXTFIELD with JavaScript solution mentioned in this message with link) - Formula set in JS (P1_SALES - P1_COST)
Now when trying to input in P1_SALES: 1000+2000
it gives 3000 in P1_PROFIT
but when I did put 1000 in P1_COST
it gives 1000(which is taking P1_COST value only) in P1_PROFIT and set P1_SALES to 0
Please advise
See lessHow to have an APEX item with arithmetic ability in APEX 19.1
Bansari
Thank you so much for quick response. This is working perfectly fine. Just one thing is that I couldn’t implement it with AutoNumeric Plug-in. It’s provide only one number input, whenever I try to input 2 numbers with + or - sign it is taking it as a negative positive number differentiation. And I rRead more
Thank you so much for quick response.
See lessThis is working perfectly fine.
Just one thing is that I couldn’t implement it with AutoNumeric Plug-in.
It’s provide only one number input, whenever I try to input 2 numbers with + or - sign it is taking it as a negative positive number differentiation.
And I really need that plug-in in order have flexibility for number format.
Can anyone please help me with it.