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?
Hi @AddOscarC,
Can you please let me know the associated information source?
Best Regards,
Bhagya
Hi @AddOscarC,
Can you please let me know the associated information source?
Best Regards,
Bhagya
The information source is “Business Planning Transaction - Valid version”
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.