Finance: Annualized Revenue

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