Skip to main content
W
WAllison
Newcomer
December 2, 2022
Solved

Cube - Use manual input as input to another column calculation

  • December 2, 2022
  • 2 replies
  • 0 views

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

Best answer by JackLacava

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)

2 replies

H
OneStream Employee
HenningOneStream Employee
OneStream Employee
December 2, 2022

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.

    J
    OneStream Employee
    JackLacavaOneStream EmployeeAnswer
    OneStream Employee
    December 2, 2022

    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)
      W
      WAllisonAuthor
      Newcomer
      December 2, 2022

      Screenshot 2022-12-02 092552.pngThank you for the response but I am still unsuccessful - these are the details of the columns in case you might have any additional insight. Many thanks.

      Manual adjustment column: F#RF_ADJ:V#VarianceExplanation:Name(Manual_Adj)

      Column to subtract: F#RF_CLO:Name(RF_CloBal)

      Formula in variance column: GetDataCell(CVC(Manual_Adj) - CVC(RF_CloBal)):Name(AdjRFClo)

      WAllison_0-1669991101416.png

      J
      OneStream Employee
      JackLacavaOneStream Employee
      OneStream Employee
      December 2, 2022

      I believe you have to reference in CVC the names of the actual columns (i.e. Col1, Col2...). Name() is an override for display purposes, it doesn't change how the rest of the system references the columns.

      Terms & ConditionsAccessibility statement