You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Skip to content
  • Register

    • Manipulating Row Dimension Member Names Using Conditional Format

    in EPM Platform and Freeform 2 comments

    Summary:

    I created a report. For the row dimension, I chose Program. When the report runs, the row members show up as:

    P_00001

    P_00002

    P_00006

    etc.

    I want to get rid of the P_ part. I can't seem to figure out how to do. For Conditional Format —> Replace Text, there is no function ability to use (e.g. Right(Program, 5). When I go to Conditional Text, there are functions to use e.g. Right(Program,5), but I can't seem to get it to take on the report. The rows still come up as P_00001, P_00002, etc.

    What am I missing? Basically, I just want the 5 rightmost characters of the program name to display in the rows on the report. I.e. 00001 instead of P_00001.

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

    Don't have an account? Click here to get started!