· 

Display SAP Minus keyfigures correct in Excel

Unfortunately, SAP export negative numbers like "Number-":

Excel minus figures display
Excel minus figures display

So you can work with this numbers, they must be changed to the format "-Number". This can be done either by hand, which is very elaborate for a large list or you can use the following Excel formula:

 

1
=MAX(C1;-SUBSTITUTE(C1;"-";""))

author.


I am Tobias, I write this blog since 2014, you can find me on twitter and youtube. If you want you can leave me a paypal coffee donation. You can also contact me directly if you want.

SAP Analysis for Office - The Comprehensive Guide
The book SAP Analysis for Office - The Comprehensive Guide by Tobias Meyer is a pdf book about SAP Analysis for Office. It is based on Analysis for Office 2.8 and contains 346 Pages.
45,00 €
SAP Analysis for Office - The Comprehensive Guide
SAP Analysis for Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis for Office. It is based on Analysis for Office 2.7 and contains 299 Pages.
37,00 €

Write a comment

Comments: 0