Forum Discussion

WAllison's avatar
WAllison
New Contributor
3 years ago

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)
JackLacava's avatar
JackLacava
Honored Contributor

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)
WAllison's avatar
WAllison
New Contributor
3 years ago

Thank 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)

  • JackLacava's avatar
    JackLacava
    Honored Contributor
    3 years ago

    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.