Forum Discussion

Filip's avatar
Filip
New Contributor II
8 months ago

Business rule to choose scenario based on Text3

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

  • Try using this format to retrieve the text from scenario:

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

     

     

  • KarlT's avatar
    KarlT
    Contributor III

    Try using this format to retrieve the text from scenario:

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