Showing results for 
Search instead for 
Do you mean 

Calculated Field Involve Date and Numeric

Skilled Commentator
Posts: 78
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'




Posts: 741
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:

Elise O'Pry
Visit our knowledgebase at