Forum Discussion

SaiKumarReddy's avatar
SaiKumarReddy
New Contributor II
2 years ago

Cell Wise Calculation

I have 50 rows and 4 columns, here I have to do a calculation with cell wise. For eg: col4row20 = col1row1 / col1row10              col4row21 = col1row2/col1row11              col4row22 = col1row3...
Cube View
  • JackLacava's avatar
    JackLacava
    2 years ago

    I think we might be picking the wrong approach here.

    CubeViews support Conditional Format statements, but that does not perform calculations (well, it can flip signs, but that's it). It also supports CubeView Extenders, i.e. custom code that can run on every intersection, but only when the CV is exported as report (because, again, it's meant mostly for formatting; but people abuse it for various things).

    For calculations, you're supposed to use expansions and overrides, which are pretty powerful and cover most average needs. If those are not enough, the calculations are clearly not simple reporting operations, but full-on calculations on complex data; so the best approach becomes working with Dynamic Calc member formulas, typically on UD8 members. Those will allow you more flexibility to pull data from anywhere.

SaiKumarReddy's avatar
SaiKumarReddy
New Contributor II

Yes I saw them, but when I entered the formula in one particular cell, the same formula is applying for all of the cells in that particular column.
for eg: in the col4 first cell I have entered formula to do the division for col1row1 / col1row10
            then I have entered the formula for col1row1 / col1row10 in the second cell,
            but the 1st cell formula is getting replaced with the second formula.

JackLacava's avatar
JackLacava
Honored Contributor
2 years ago

That sounds like you need to use Row Overrides (on columns) and/or Column Overrides (on rows).

  • SaiKumarReddy's avatar
    SaiKumarReddy
    New Contributor II
    2 years ago

    Looks like we can use row overrides upto 4, If I have 20 multiple diff formulas how can I achieve it with in only 4 overrides

  • SaiKumarReddy's avatar
    SaiKumarReddy
    New Contributor II
    2 years ago

    Else, is there any process to use the parameter and saying the condition like if the row name equals to ***** then perform this calculation, if its there please give me the example formula how to use that.

    • JackLacava's avatar
      JackLacava
      Honored Contributor
      2 years ago

      I think we might be picking the wrong approach here.

      CubeViews support Conditional Format statements, but that does not perform calculations (well, it can flip signs, but that's it). It also supports CubeView Extenders, i.e. custom code that can run on every intersection, but only when the CV is exported as report (because, again, it's meant mostly for formatting; but people abuse it for various things).

      For calculations, you're supposed to use expansions and overrides, which are pretty powerful and cover most average needs. If those are not enough, the calculations are clearly not simple reporting operations, but full-on calculations on complex data; so the best approach becomes working with Dynamic Calc member formulas, typically on UD8 members. Those will allow you more flexibility to pull data from anywhere.