Community
Showing results for 
Search instead for 
Do you mean 
Reply

Calculated Field Involve Date and Numeric

Skilled Commentator
Posts: 71
Country: United Kingdom

Calculated Field Involve Date and Numeric

Hi - I have a calculated field, under opportunities that shows me ('DAYS-TO-GO) to the estimated close date.

(Its much easier to read - rather than looking at the close data itself, presenting a number such as 10 - being 10 days to go till the estimated closing

 

I want to then multiple this figure by the Weighted Total (and perform other calculations)

 

The issue is - The formula box - when selecting Numeric Calculated Field only gives me

Weighted Total/ Total / and Gross Margin

 

My defined field (DAYS-TO-GO) is no where to be seen - meaning I cannot select it to be part of the formula.

 

Can any one help - or point to my misunderstanding of 'calculated fields'

 

 

 

Moderator
Posts: 719
Country: USA

Re: Calculated Field Involve Date and Numeric

Act! cannot do calculations based on data that is found within a calculated field. You can only do calculations based on standard number fields. 

 

For more advanced calculation options, you may be able to find a third-party addon here: http://www.act.com/marketplace/

Elise O'Pry
Swiftpage
Visit our knowledgebase at http://kb.act.com