Analysis Office: How to work with Excel formulas

Kommentare

8 Kommentare zu „Analysis Office: How to work with Excel formulas“

1. 

   15. März 2019

   Iwan Santoso

   Hi Tobias, Have you come across situation where you move your AO workbook to Test environment via transport and get the formula to be available in the target system? my situation is that in target system, the formula is left blank and it works fine in development environment. Regards, Iwan

   Antworten
2. 

   16. März 2019

   Tobias

   Hi Iwan, is your workbook stored in BW or on a BIP? I have workbooks on a BIP and no problem with any formulas. The created columns with Table Design are also visible in your target system? Best regards, Tobias

   Antworten
3. 

   27. März 2019

   DAmian

   Hello tobias: we are trying to write a formula in SAP IP but for some reason the formula dissappears and the value only remains. Any suggestions woulr be welcome. Thanks!

   Antworten
4. 

   28. März 2019

   Tobias

   Hi Damian, can you send me your example via mail? On which version are you? It seems like a bug. Best regards, Tobias

   Antworten
5. 

   20. August 2020

   Othmar

   From experience: 1. Workbook must be connected with the Datasource with activated updating (should be obvious, but can be a source, why things don’t work as expected.) 2. If there are too many values selected, the copying down the formulas does not work correctly; therefore select first less data, write your formulas and then reupdate the Workbook with all the data needed.. 3. If Excel-Formula is not supported by AO, the Formula disappears – or at least just gives N/A back. (Easy formulas like Sum, Medium; Add / Minus; Multiplication / Division work fine. Even referencing to cells out of the AO-Workbook. Not possible: vlookup, if – then, etc.). @Tobias: A list of supported formulas/functions would be appreciated if available. (Could not yet find something)

   Antworten
6. 

   31. August 2020

   Tobias

   Hi Othmar, in the ebook you find a more information about formulas. What exactly are you looking for? Normally you can use all Excel formulas. If you like we can exchange via mail. Best regards, Tobias

   Antworten
7. 

   6. Mai 2021

   Rupad

   Hi Tobias, In my AFO report I have hidden some rows using VBA Macro depends on requirements. after display, when I click anywhere in the report the hidden rows coming back again. looks like Excel macros/formulas not persist on the crosstab. Can you please let me know how to control this issue? Is it possible to handle with CallBack events? Regards, Rupid

   Antworten
8. 

   6. Mai 2021

   Tobias

   Hi, when your hidden rows inside the Crosstab, then it will be shown after refresh. You can use the Callback Events (I have another example in my book). Best regards, Tobias

   Antworten