Skip to main content

Hello @all.

 

I have the following request and could use a little help from the experts around here :)

On an opportunity there are different products. I already have a roll-up-summary-field which counts the quantity of the opportunity products (like 18,00 or 65,00 etc).

 

And here comes the fun part: I need this number auto populated in a dedicated custom field without the dezimal format and only if the products have a dedicated productnumber.

 

If the selected products have a diffrent product code then ignore the rule. It screams validation rule but I´m fairly unexperienced when it comes to this kind of logic.

 

Is there a good samaritan who knows how to write that?

 

Kind regards.

Alex

 

#Validation Rules #Sales Cloud #Formulas #Automation

5 answers
  1. Feb 14, 2023, 8:44 PM

    That helps a bit. Still not sure on the "dedicated product number" part.

     

    If there is only one dedicated product numbers then you should be able to add it to Filter Criteria section. I don't think you'll be able to do multiple as filter criteria is AND operator only

     

    If you use roll-up summary you cannot remove the decimals. https://ideas.salesforce.com/s/idea/a0B8W00000GdcUQUAZ/control-decimal-places-on-rollup-summary-fields

     

    I think you need  to create this with flow or a different rollup tool (DLRS, rollup helper).

     

    Flow instructions: https://www.salesforceben.com/create-roll-up-summary-fields-using-salesforce-flow/

     

     DLRS Documentation

0/9000