Question

Functional Parameter BR - Next Business Plan ID

  • 25 March 2022
  • 3 replies
  • 60 views
A
Rank
Userlevel 1
Badge +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 comments

3 replies

B
Rank
Userlevel 5
Badge +13

Hi @AddOscarC,

Can you please let me know the associated information source?

Best Regards,
Bhagya

A
Rank
Userlevel 1
Badge +2

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
Rank
Userlevel 5
Badge +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 settings