Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers