Totalling Opportunities

[ch1p]

When looking at a company the opportunity tab will give a total of all listed opportunities.  Is there any way of capturing this information and putting in a field in the associated company table? 

[jimdurkin · Accepted solution]

Using the ACT SDK use somthing like this...

// Sudo code

Dim opportunityList as Act.Framework.Opportunities.OpportunityList = nothing

opportunityList = Me.HostFramework.Opportunities.GetOpportunitiesByCompany(Me.HostApplication.ApplicationState.CurrentCompany.ID, Nothing, aFilter)

Dim total as decimal = 0D

  For Each opp As Act.Framework.Opportunities.Opportunity In opportunityList
total += opp.ProductTotal
Next

Hope this helps

-- Jim Durkin

[jimdurkin · Accepted solution]

Using the ACT SDK use somthing like this...

// Sudo code

Dim opportunityList as Act.Framework.Opportunities.OpportunityList = nothing

opportunityList = Me.HostFramework.Opportunities.GetOpportunitiesByCompany(Me.HostApplication.ApplicationState.CurrentCompany.ID, Nothing, aFilter)

Dim total as decimal = 0D

  For Each opp As Act.Framework.Opportunities.Opportunity In opportunityList
total += opp.ProductTotal
Next

Hope this helps

-- Jim Durkin

[ch1p]

Tanks Jim,

Will try and put something together with this in it,