This Dynamic Calc formula calculates Annualized Revenue, by taking 3 months of Total Revenue, dividing it down to a monthly amount, then multiplying it by 12.
' "Prior Scenario" must be stored as Text1 property in current Scenario
Dim priorScenario As String = api.Scenario.Text(1)
Dim objTimeMemberSubComponents As TimeMemberSubComponents = BRApi.Finance.Time.GetSubComponentsFromName( _
si, api.Pov.Time.Name)
Dim periodNum As String = "M" & objTimeMemberSubComponents.Month.ToString
Select Case periodNum
Case "M1"
Return api.Data.GetDataCell( _
"((A#TOTREV:U1#Top:V#Periodic:I#Top" & _
$" + A#TOTREV:U1#Top:V#Periodic:I#Top:S#{priorScenario}:T#PovPrior1" & _
$" + A#TOTREV:U1#Top:V#Periodic:I#Top:S#{priorScenario}:T#PovPrior2)" & _
" / 3) * 12")
Case "M2"
Return api.Data.GetDataCell( _
"((A#TOTREV:U1#Top:V#Periodic:I#Top" & _
" + A#TOTREV:U1#Top:V#Periodic:I#Top:T#PovPrior1" & _
$" + A#TOTREV:U1#Top:V#Periodic:I#Top:S#{priorScenario}:T#PovPrior2)" & _
" / 3) * 12")
Case Else
Return api.Data.GetDataCell( _
"((A#TOTREV:U1#Top:V#Trailing3MonthTotal:I#Top / 3) * 12)")
End Select
