Questions about Cube Views and Reports
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Max/Min Calculation Row in CV

Hello! I received a request to add a maximum and minimum line to a cube view. The cube view shows entities in columns and a variety of accounts in the rows (not together in a hierarchy, so no .base or .children, just a list separated by commas). Max/...


Resolved! Copy Actual to Forecast issue

Hi all, We have a simple copy calculation on a forecast scenario that copies in the actuals data for certain periods, defined in a text field. We've had it for years and it generally works fine with no issues. This quarter though, I'm having an odd i...

NicoleBruno_0-1648591516845.png NicoleBruno_1-1648591805177.png

Resolved! Calculate variance percentages for different rows

HiI'm struggling to add lines to show Gross Margin % ((Total income less product related costs)/Total income)*100), overhead as a percentage of total income etc.I've tried using Getdatacell referencing the rows but clearly am doing something incorrec...

CrispinC by New Contributor II
  • 3 replies
  • 0 kudos

Explosion Factor - Explanation

SOURCE: ONESTREAM CHAMPIONSHi Team,Can someone suggest a guide or explanation on how the Explosion Factor is Calculated ? image.png1372×629 73.8 KB Best Regards and ThanksDarpan Bhansali

darpan13 by Contributor
  • 7 replies
  • 2 kudos

Account formula help

SOURCE: ONESTREAM CHAMPIONSHi all,I have a very random request for anyone who may have the time to review and hopefully point me in the right direction.The formula calc is an on account and is unbalanced - I’m specifying more dimensions on the right ...