OneStream Community

SaiKumarReddy · 05-12-2023

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/col1row12Likewise I need to input the multiple formulas for the cells, here what...

SaiKumarReddy · 05-07-2023

A#Cash.TreeDescendantsInclusive.Where(Text8 = L1).I have used the above formula to display only level1 members of one account but now I want to like to display level1 members along with the parent members of L1.Help me out in reframing the above form...

SaiKumarReddy · 05-13-2023

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.

SaiKumarReddy · 05-13-2023

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 · 05-12-2023

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 ...

OneStream Community

User Statistics

User Activity

Cell Wise Calculation

Show L1,L2 in Cube View

Re: Cell Wise Calculation

Re: Cell Wise Calculation

Re: Cell Wise Calculation