Skip to Content
0
Feb 15, 2011 at 01:17 AM

how to derive a column (not key figure)

27 Views

dear all, i am hoping this is going to be a quick on.

i simply need to derive or change a cell's data or description.

it is not a key figure

it's as if i need to access it via an exit and return the desired value.

for example, if the cell says "A" i want to put in "1", if the cell is "B" a "2". as simple as that.

i am stumped whether i do this via a global variable, replacement path, text variable or what ?

any pointers and examples would be great

thanks

g