By default show summary of cells in the bottom right corner
Like in Excel it would be nice to get an automatic summary of cells shown in the bottom right Corner (see attached file).
For example:
Value in cell A1: 20
Value in cell A2: 30
Value in cell A3: 40
When range A1:A3 is selected, the sum of those ...
PALO.DATA.SOURCE Identify rule-based values/cells
Function to identify, if a value is calculated or stored in the database.
This enables dynamic reports where a conditional formatting opens cells for data entry ONLY if they are actually stored an...
Hatched fillings for bar charts would allow distinguishing between scenarios without relying on a chart legend or different colors. The IBCS also recommends this. It is also a functionality provided in Excel and it would enrich Web Reporting.
Show Dimension-Name in palo.data-function in web reports
When one is inserting the palo.data-function in Excel, the function shows always the name of each dimension followed by the default element; so the user can easily identify the dimension to change the reference value. By inserting the palo.data-fu...
Add paging in reports for Legal Entities (including the ones listed for workflow)
Sometimes, there are many Legal Entities at customers, paging function would be needed in reports: "Scope of consolidation", "Data collection", "Consolidation Manager", "Consolidated Financial Statement".
Translation: use default language in reports if system language not available for reports
Currenty if adding the feature multilanguages we has two possibilities: 1) Using the following formula: =PALO.DATAC(rngDB;"#__Translation";"Name";"1000130";rngLanguage) I translate the text in german and french. My default language is english. If ...