How to change displayed value to user-specified text?

[Former Member]

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!

[Former Member · Accepted solution]

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.

[Former Member · Accepted solution]

Hi,

Thanks for your input.

I have tried to Boolean Logic as described but is having difficulties to replace it with text. The formula will gives me amount (percentage) value but I need to replace it with text ">100%" if above criteria is met.

Appreciate if someone could show me how to accomplish this using ABAP or any other methods.

Thanks!

[Former Member · Accepted solution]

Try to define cell level and get the text as display

[Former Member · Accepted solution]

There is a better and simple way to fix the problem.

Would it be possible that you can change a way to present the result?

You can use condition, which can simply add color to the cell with value > 100%

You can put a text remark as "The variance with greater than 100% are marked as red" above your query.

For user, they can found the result > 100% easy and they can find the actual value at the same time.

[Former Member · Accepted solution]

Hi Matthew,

Do you mean cell definition in Query Designer? Could you please explain on how to achieve that?

Thanks.

[Former Member · Accepted solution]

Hi Brian,

That would be a good solution but this report will be presented to the management and they have a certain format that I have to follow.

User would access the report from the web and then export it into PDF. In the report presented to the management (in PDF format), I need to display all variance values that exceed 100% to ">100%". So, if I can't do that via query, is it still possible to do so via either view, report or web template?

Thanks!

[Former Member · Accepted solution]

User would access the report from the web and then export it into PDF. In the report presented to the management (in PDF format), I need to display all variance values that exceed 100% to ">100%". So, if I can't do that via query, is it still possible to do so via either view, report or web template?

-

---

I haven't use it before but i am wandering that customer exit may possible to fix the problem.

It support all kinds of variable.

[Former Member · Accepted solution]

Yup, customer exit might solve the problem.

Can anyone guide me on how to write one?

Thanks!

[Former Member]

Hi,

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

Regards

Pcrao.

[Former Member]

Hi Pcrao,

Thanks for the input.

OK now, the user would actually access the report via web report. So, we are utilizing web template, report, and view for this purpose.

Just curious, can we use Workbook as data source for Report? Currently, it is using View. So, if it is possible, then I might be able to do like what you have suggested.

[Former Member]

Hi,

we dont have option to use workbook in web template. we can use only query or view.

If your user wants to see the report directly(excel format report) then use workbook.

Regards

Pcrao.

[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.

[Former Member]

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

[Former Member]

Hi,

Thanks for the hint. I am going to explore that possibility and let you know the result.