Calculate two numeric field
I have two numeric fields “Numeric1” and “Numeric2” i want another numeric which can give me results addition of Numeric1+Numericc2.
How can i achieve this.
Should i need to use any pxcode or SDk to solve my problem.
Thanks in Advance…..
You would need to use a PX to do this using an event like update title block to trigger. I would think for a simple calculation a groovy script would suffice.
You can manage that on update title block event as discussend in that question
https://myagileplm.com/questions/checking-or-compiling-fields-with-update-title-block-trigger/
Anyway it is not a good idea to store the sum in a field because if any issue, other values can not be synchronized with that field. If it is relevant for reporting,maybe you can create a custom report that will sum values at runtime and put result in the report without store it
In The java client admin tab:
System setting -> Event management – Events Create an event on which the calculation should be triggered I would guess its update title block or update table depending on where your attributes to be added together are located.
System setting -> Event management – Event Handler: Create an event handler if your using Script PX you enter your code here suggest you seek out the Oracle Agile code samples web page for examples of script PXs. There will be something there that demonstrates reading and writing attributes to base your PX on.
System setting -> Event management – Event Subscribers: Set up a subscriber to catch the event and trigger the handler, Easiest is to have set to post i.e. after the update table has committed the data to the database.