Calculate opp amount by the sum of RL amounts

Hi,

I am new to formula.

I am trying to find out how to create a formula in opp amount field which was the sum of all related RLI amounts.

Can anyone help me?

Riccardo Arienti

Parents Reply
  • Dear

    Thank you :)

    Try the following in the Studio

    1. Clone the Opportunity field [Amount] (its label is "Likely") and name, e.g., "total amount" or as you need.
    2. Press edit the formula of this new field and change "likely_case" to "total_amount" in the formula text
    3. Save changes
    4. Place this new field in the record view

    Don't' forget to save and deploy your changes.

    The RLI's field [total_amount] (label "Calculated Amount") is calculation [Q-ty] * [Price].

    I hope you'll get what you are looking for.


    Regards,
    Mykola

    Integroscrm.com
    We make work in Sugar
    more convenient and efficient

Children