A while back I wrote a blog about regions within regions in IBM Planning Analytics. This approach allows you to make your rules easier to navigate and read when scrolling through … [Read more...] about IBM Planning Analytics Tips & Tricks: Planning Analytics Workspace (PAW) Region Expansion
Top Three IBM Planning Analytics Tips & Tricks Posts – 2023
What were your favorite IBM Planning Analytics Tips and Tricks blog posts this year? We took a look at our website analytics and found the top three posts of 2023 are (drumroll, … [Read more...] about Top Three IBM Planning Analytics Tips & Tricks Posts – 2023
IBM Planning Analytics Tips & Tricks: Excel TEXT Function
Have you ever merged text and a calculated number into a cell and saw that the format of the number was hard to read? The TEXT function in Excel lets you convert the number into a … [Read more...] about IBM Planning Analytics Tips & Tricks: Excel TEXT Function
IBM Planning Analytics Tips & Tricks: PAW Pie Chart Total
Pie charts are a type of visualization known as composition. Composition charts are designed to show the parts of a whole. This is a great way to look at the pieces of total. For … [Read more...] about IBM Planning Analytics Tips & Tricks: PAW Pie Chart Total
IBM Planning Analytics Tips & Tricks: PAW Generated Statements
One of the great things about IBM Planning Analytics Perspective’s process editor is that the wizard can be used to create code within your scripts. The results of the wizard based … [Read more...] about IBM Planning Analytics Tips & Tricks: PAW Generated Statements
IBM Planning Analytics Tips & Tricks: Excel Switch Function
The SWITCH function in Excel evaluates a condition and then provides a result based on that condition. This function is similar to a SQL CASE statement and allows for up to 126 … [Read more...] about IBM Planning Analytics Tips & Tricks: Excel Switch Function
IBM Planning Analytics Tips & Tricks: Excel Substitute Function
Are you familiar with the SUBSTITUTE function in Excel? The SUBSTITUTE function in Excel replaces one value with another. This is similar to the REPLACE function, but SUBSTITUTE … [Read more...] about IBM Planning Analytics Tips & Tricks: Excel Substitute Function
IBM Planning Analytics Tips & Tricks: Excel’s ROUND Function
Most standard financial reports round to some form of a large value. For example, the report may show numbers in millions or rounded to the nearest 100,000. This is done in … [Read more...] about IBM Planning Analytics Tips & Tricks: Excel’s ROUND Function