Skip to main content
May 16, 2024
Solved

Business rule to choose scenario based on Text3

  • May 16, 2024
  • 1 reply
  • 0 views

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

Best answer by KarlT

Try using this format to retrieve the text from scenario:

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

 

 

1 reply

KarlTAnswer
May 16, 2024

Try using this format to retrieve the text from scenario:

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

 

 

FilipAuthor
May 16, 2024

Thanks a lot for the help.