How to set up rules to add together several fields and then subtract
How do I set up the Rules in a request type in PPM workbench to add together several columns and then subtract the value of several other columns that have been added togher. For example I have several columns of estimated cost information and then I have those same columns for actual cost information. I then want to subtract the estimated cost columns from the actual cost columns. I'm not certain how to set up the sql in the Rules with the tokens to do the calculation. I have attachments.
If the second rule is based on updates of the same fields, you can use the same rule (2 results for one field, 4 results for two fields, ...).
As you have a lot of fields, I suggest you to use some functions. You can prepare four different functions or prepare four functions in one package (search for ORACLE CREATE PACKAGE and ORACLE CREATE PACKAGE BODY).
I know that it's possible to prepare one function that gives different results, but I never experienced it. If I find additional information, I let you know.