Business rule to choose scenario based on Text3

Filip
New Contributor II

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

1 ACCEPTED SOLUTION

KarlT
Contributor

Try using this format to retrieve the text from scenario:

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

 

 

View solution in original post

2 REPLIES 2

KarlT
Contributor

Try using this format to retrieve the text from scenario:

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

 

 

Filip
New Contributor II

Thanks a lot for the help.