Enterprise & Sell

Enterprise & Sell Answers & Best Practices Calculated Field - no of sales

Click here to join this group and curate your SugarClub experience.

Calculated Field - no of sales

Geraldine Hunt over 2 years ago

HI,

Wondering if someone could help.

I'm trying to create a calculated field on an account to return a count of all opps on the account that are at a certain sales stage and type = NEW?

I also want to add in a count per product - 1 opp at sales stage A for product X, 1 Opp at sales stage A for product x .

Thanks

Ger

Ge

Parents

0 André Lopes over 2 years ago

Core sugarLogic formulas are unable to conditionally count based on 2 or more fields.

Instead you can setup a BPM process which populate/update a set of custom fields on the Account based on specific fields from a target module (Opportunities, RLI).

Good luck!

André Lopes
Lampada Global

Skype: andre.lampada
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 André Lopes over 2 years ago

Core sugarLogic formulas are unable to conditionally count based on 2 or more fields.

Instead you can setup a BPM process which populate/update a set of custom fields on the Account based on specific fields from a target module (Opportunities, RLI).

Good luck!

André Lopes
Lampada Global

Skype: andre.lampada
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data