Skip to Content

[SAP BW] Question on Percent Style display in an output report.

Oct 09, 2017 at 12:01 PM


avatar image

Hi Community,

I am a complete beginner in SAP BW and working on my first real project. One of the output columns has to display if an order line was delivered in full (based on some criteria) and be in percent style. Elaborating:

The CKF's formula is as follows: IF('0ORDER_QUAN' == '0GR_QTY_PD'; 1; 0). Obviously, it returns either 1 or 0 and that's ok, but how do I display 100% and 0% instead of 1 and 0 respectively? Of course I can apply Percent Style in Excel (after the results are shown in the Analyzer add-in), but is there a way to do that yet at query designer level?

Thanks in advance,


Edit: I have already found the solution. Just in case somebody have faced the same problem and looking for answer - instead of '1' and '0' in the value_if_true and value_if_false parts of the IF function, use '1 %A 1' and '0 %A 1', which will return you values in percent. That's easy.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers