On 2/18/2015 4:19 PM, jose i cabrera wrote: > I need to know what the percentage for this specific project ID, 132959, > and language is going to be calculated. This may be different depending > on the project. So, it may be 3%, 5%, 10%, 20%, 25%, etc. That is my > problem, I don't know how to grab that without this step.
Where is this information coming from? How do you know that RateType = '10%' corresponds to 0.20 multiplier? How is your hypothetical trigger supposed to know that? -- Igor Tandetnik