IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Users and Groups
Do you know how to manage your users and groups in IBM Planning Analytics Workspace (PAW)? As of version 84, PAW now allows you to edit this information via a single click. To open the users and groups editor, right-click on a…
April 18, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel Tips, Part 3
Revelwood’s IBM Planning Analytics team has created numerous tips & tricks focused on helping people use Excel. Over the next few weeks, we’ll be highlighting some of the most popular and interesting posts on Excel. If you’ve missed our earlier posts, read…
April 11, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: UNIQUE Function in Excel
Have you ever needed to produce a list of unique values within a cell range in Excel? If so, the UNIQUE function can do this. The example below shows a simple list of countries that includes some duplicates: To produce a unique…
April 4, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: On-Demand Webinars, Part 2
Did you know we have a wide variety of IBM Planning Analytics webinars on-demand? We showcased two of our most popular webinars – Best Practices when Using Planning Analytics Workspace Charts and Creating PAW Charts Using the New Experience – in a…
March 28, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips and Tricks: Upgrading to Planning Analytics for Excel 2.0.65 or later
As of version IBM Planning Analytics version 2.0.65, you can choose to either launch IBM Planning Analytics for Excel (PAx) as a single session (by double-clicking the .XLL file) or load it as an add-in (and have it available for all Excel…
March 21, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel YEARFRAC
I often build models that define the fraction of a year for a given month. For example, January is approx. 8.5% of a calendar year (31/365) and September is approx. 11.5% of a working day’s calendar (30/260). But what happens in situations…
March 14, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: On-Demand Webinars, Part 1
So many webinars, so little time! If you are like me, you probably receive invitations to webinars on a regular basis. Some of them even make it onto my calendar. Unfortunately, more often than not, I have the best intentions of attending…
March 7, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel Tips, Part 2
Revelwood’s IBM Planning Analytics team has created numerous tips & tricks focused on helping people use Excel. Over the next few weeks we’ll be highlighting some of the most popular and interesting posts on Excel. You can read part 1 here. IBM…
February 28, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel EOMONTH
Thirty days has September … Do you sing that out loud every time you want to determine the number of days in a month? If so, do you have to pause and think about the end when defining the last day of…