Calculated Field doesnt allow the use of today() function

[Sudowoodo]

Hi all,

I am trying to make a predictive calculation by using this formula yearly/quarterly/monthly
Forecast = sum of current revenue / current days past in year * number of days in year
However when i use the formula I want it gives me an error saying that the function today() is not supported so I dont know how to work around this. Thanks in advance for the help.

 

[jim may]

Hi all,

I am trying to make a predictive calculation by using this formula yearly/quarterly/monthly
Forecast = sum of current revenue / current days past in year * number of days in year
However when i use the formula I want it gives me an error saying that the function today() is not supported so I dont know how to work around this. Thanks in advance for the help.

Post the formula you are using

 

[Sudowoodo]

Post the formula you are using

=Revenue/(TODAY()-DATE(YEAR(TODAY()),1,1))*(DATE(YEAR(NOW()),12,31)-DATE(YEAR(NOW()),1,1)+1)