· 

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.

Analysis Office - The Comprehensive Guide 5th edit
The book SAP Analysis 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.
59,99 €
Analysis Office - The Comprehensive Guide 4th edit
Analysis Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis Office. It is based on Analysis Office 2.7 and contains 299 Pages.
39,99 €

Write a comment

Comments: 0