Hi,
I need help to write the formula for " Net Amount " in a business process.
The business process is as below screenshot.
When I am trying to use Selection result in Formula popup I am getting the following error: "Process element "Selection result" not found. "
I need to apply a filter in Commission Rules Selection based on that "Net Amount will be calculated.
The criteria are as below. "Using the [Distribution_Channel] in the policy register object, query the Commission Rules for that [Distribution_Channel] and cycle through each commission rule. Each rule represents a single Bill. Use the [Commission_Rules.Rate] and [Commission_Rules.Rate_Type] as an input in the formula.
IF [Commission_Rules.Rate_Type] = Percentage
Net Amount = [Base_Premium] x [Commission_Rules.Rate] ELSE
IF [Commission_Rules.Rate_Type] = Flat
Net Amount = [Commission_Rules.Rate] "
Thanks in advance.
Like
Dear Jitendra,
For if statement in a formula you can use conditional operator :
https://docs.microsoft.com/en-us/dotnet/csharp/language-reference/operators/conditional-operator
However, unfortunately, you can't loop through records in the formula. To fulfill your business task you would need to use script task, selecting the needed Commission rules records, looping thorough them and creating Bills based on it.
Here are academy articles that would help you with that:
For selecting Commission rules with a filter
https://academy.creatio.com/documents/technic-sdk/7-15/introduction-13
https://academy.creatio.com/documents/technic-sdk/7-15/retrieving-information-database-select-class
For adding new Bill
https://academy.creatio.com/documents/technic-sdk/7-15/working-database-entity-entity-class