Hello,
I am fairly new but I have a quite ambitious project that I want to get done at my workplace...I am trying to understand when should I use a calculated field or a business rule and what advantages would bring if I do a certain task with the business rule.
In practice, I would like to input 2 parameters for different cases, cases 1, 2 and 3. Then I need the app to calculate a value for each parameter, evaluate which value is greater and then compare the greater value for all the cases and take the greatest value of all (worst case scenario). Then if the worst case scenario is greater than an input value, show a message.
I kind of did it through the calculated fields, but for each passage I have to create a new field. If I go through the business rule, will I have any advantage, like eliminate some intermediate field that I do not need to store? Also, when I created a business rule, I noticed you cannot multiply 2 fields and to another number, is it right? I think I can do as a succession of steps but it seems strange to me that in one step I cannot do field a*fieldb*2. Is this correct or am I missing something?
Thank you.