While working in OneStream, users may experience formatting issues when trying to get a ratio by dividing a specific POV by another POV. A formatting issue happens when the denominator is 0, and since you can't divide by 0, formatting the equation improperly will result in a formatting issue when viewing the results. This issue can appear while using cube view math, member formulas, or business rules. If you don't use the proper expressions while writing your equation, you will see the issue arise when you open a CubeView or a Dashboard that is using the expression.
The first example is trying to use a GetDataCell expression in the last column to retrieve the year-over-year result. The GetDataCell being used can be seen below, followed by the results of the data explorer view.
As you can tell from the results, OneStream spits out a long string of numbers for the line item that has a 0 as the denominator. To fix this issue using cube view math, make sure you use the proper GetDataCell Divide Expression.
After updating your column GetDataCell expression, you can see that OneStream shows nothing for the result as you can't divide by 0.
The same issue occurs when dividing using any kind of business rule. For example, below, I am using an XFBR to retrieve the data, and you will see that the result is the same as the cube view example.
Using OneStream's divide function will fix this issue and ensure your results are recorded correctly.
Want to know more about Automating Oracle Cloud Admin Tasks? Please complete the form below and we'll get back to you shortly.
OneStream aligns to your business needs and changes more quickly and easily than any other product by offering one platform and one model for all financial CPM solutions. OneStream employs Guided Workflows, validations and flexible mapping to deliver data quality confidence for all collections and analysis while reducing risk throughout the entire auditable financial process.