DevClub

Dev Answers & Best Practices Updating my formula

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

Thread Details

State Not Answered
Replies 2 replies
Subscribers 354 subscribers
Views 810 views
Users 0 members are here

Forum Actions

Related

Updating my formula

Ada Napierala over 2 years ago

Hi,

I would like to update my Total Contract Value formula. At the moment this is it:

rollupConditionalSum($revenuelineitems,"total_amount","sales_stage",forecastSalesStages(true,false))

I would like this field to sum from additional fields from revenue line items - is that possible?

Thank you!

0 Andre Serrazina over 2 years ago

Hello Ada Napierala,

You could try including this in an add() formula with your custom fields.
Something like this for a custom field named custom_field1_c:

add(rollupConditionalSum($revenuelineitems,"likely_case","sales_stage",forecastSalesStages(true,false)),related($revenuelineitems,"custom_field1_c"))
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Ada Napierala over 2 years ago in reply to Andre Serrazina

Thank you Andre :)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel