Skip to Content
avatar image
Former Member

How to change displayed value to user-specified text?

Hi experts,

I have the following requirement:

- For all variance >100%, instead of displaying the exact value of variance, e.g. 432%, I need to simply display ">100%".

Is this achievable in:

1. Query

2. Web Template?

Appreciate your feedbacks. Thanks!

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 20, 2008 at 03:39 AM

    You can use boolean logic in formular in query desginer. But i am not sure how to display ">" before 100 in the formular.

    Take the "Percentage" as example, the formula of calculated key figure may looks like:

    (Percentage < 100%) * Percentage + (Percentage >= 100%) * 100%

    Maybe you need to write a ABAP program to fix this problem.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 17, 2008 at 10:54 AM

    Hello,

    You might want to use the functions provided while creating the KF. I dont exactly remember the syntax it should be put in there, but it would provide you with something like

    'If then else' thing.

    Regards

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 20, 2008 at 06:35 AM

    Hi,

    Use Excel formula to display >100% in the result of 432% and save it as a workbook.

    Regards

    Pcrao.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Thanks Pcrao.

      At the moment the requirement is in PDF.

      Earlier, I tried to add a column and saved it as View, but it won't allow me to do so. I guess it will only work with Workbook.