Skip to main content
Question

Functional Parameter BR - Next Business Plan ID

  • March 25, 2022
  • 3 replies
  • 67 views
A
Do Gooder (Partner)
Forum|alt.badge.img+2

What function do I use to create a functional parameter that replace for example business plan id F2022Q1 with F2022Q2, i.e. next courter?

If the business plan id would be a number value I could use function ADD but business plan id is a string and I can’t use it as a parameter value as number?

This topic has been closed for replies.

3 replies

B
Superhero (Employee)
Forum|alt.badge.img+13

Hi @AddOscarC,

Can you please let me know the associated information source?

Best Regards,
Bhagya

A
Do Gooder (Partner)
Forum|alt.badge.img+2
  • AddOscarC
  • Author
  • Do Gooder (Partner)
  • 4 replies
  • March 29, 2022

Hi @AddOscarC,

Can you please let me know the associated information source?

Best Regards,
Bhagya

The information source is “Business Planning Transaction - Valid version”

B
Superhero (Employee)
Forum|alt.badge.img+13

Hi @AddOscarC,

I think there is no straight forward way. But you can try it out using several functions such as
→  SUBSTRING (Take the portion of the number you want),
→ TO_NUMBER
→ ADD (Add one)
→  CONCATENATE

Best Regards,
Bhagya

Terms & ConditionsCookie settingsAccessibility statement