Business rule to choose scenario based on Text3

[Filip]

Hi,

I am trying to create an account member formula where I have Account A divided by Account B, but the scenario in the denominator should be decided based on Text3 in the POV Scenario.

E.g. 
A#10000:S#Actual / 
A#20000:"& SourceScenario &"

SourceScenario = IF Pov.Time + 12  > Scenario Text 3, Then
SourceScenario = Forecast, Else
SourceScenario = Actual

This is how far Ive come but it is not working yet:

'Use FC as scenario if POV time is more than 12 months more than last seeded actual month in FC.
If api.Pov.Scenario.Text(3) > api.Time.AddTimePeriods(12, True) Then
DenominatorScenario = ":S#FC_WIP"
Else
DenominatorScenario = ":S#ActualL4LAtRealRate"
End If

[KarlT · Accepted solution]

Try using this format to retrieve the text from scenario:

api.Scenario.Text(api.Pov.Scenario.MemberId, 3)

[Filip]

Thanks a lot for the help.