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

Forum Posts

How do I override CV cells?

I have a report that uses it's own conditions to calculate a value. Is their a way to over-ride the blank/data cell in cube view, and have it run a simple IF conditional calculation?Most of these conditional calculation are for KPI's (basically forec...

Mustafa_A_0-1644865147431.png
Mustafa_A by Contributor II
  • 70 Views
  • 1 replies
  • 0 kudos

Resolved! GetData CVC function for rows

Hi All,Do we have a function to get data from a row within CV? For e.g. GetDataCell(CVC(Rental Revenue) / CVC(Fleet Actual)) I tried using this method but keep getting a syntax error. Any suggestions in the right directions will be appreciated. Thank...

Mustafa_A_0-1644254214752.png
Mustafa_A by Contributor II
  • 175 Views
  • 4 replies
  • 0 kudos

API for calling a parameter

Dear Community - I'm building a dynamic prior year formula for my Variance Cube view. However I want to pull the MonthNo (e.g. M10) from the parameter I have |!SelectCol1Period!| so that it can reference the accurate period based on selected by user ...

Mustafa_A_0-1638907022596.png
Mustafa_A by Contributor II
  • 182 Views
  • 1 replies
  • 0 kudos
Labels