Forum Discussion

WAllison's avatar
WAllison
New Contributor
3 years ago
Solved

Cube - Use manual input as input to another column calculation

In a cube view, how can I use a manual input value in the formula in another column? Col1 Col2 Col3 EndBal Input Value EndBal - InputValue Many thanks in advance. Winni
Cube View
  • JackLacava's avatar
    JackLacava
    3 years ago

    I suspect what you're after are the CVC and CVR functions. Have a look at the section "Calculated Columns and Rows with References to Columns and/or Rows" in the Design and Reference Guide, which includes examples like

    GetDataCell(CVC(Col1) - CVC(Col2)):Name(Variance)
Henning's avatar
Henning
Icon for OneStream Employee rankOneStream Employee
3 years ago

Hi Winni, apologies, but I have no idea what you mean here. May I ask you to add some descriptions of what you actually want to achieve? And a why, so that we can assess if what you are looking for needs a dynamic calc, CV math, stored calc, etc.?

A draft in Excel with sample data would help as well.