Skip to Content
0
Former Member
Sep 07, 2009 at 11:39 AM

APO macro as excel function =LEFT or =RIGHT

61 Views

Hi all,

in demand planning process I am using a customer specific characteristic which is a string of several numbers.

By one specific digit out of this string it has to be differentiated whether calculation logic A or B has to be executed.

Example:

9 9 9 1 9 9 --> calculation A

8 8 8 1 8 8 --> calculation A

9 9 9 2 9 9 --> calculation B

8 8 8 2 8 8 --> calculation B

Is there any macro functionality like the excel function "=left" or something else which can return the value of this string's certain digit of the actual selected CVC?

By the way, I don't want to solve this by creating an additional characteristic/attribute oder changing the CVC structure...

Any help would be highly appreciated!

Julian