The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Cube view
I have 2 rows named row1 and row2. 1. Row1 has two members namely A and B. 2. Row2 has three members namely C,D and E. Now, I want to add row1 and row2 so that it sum all A,B,C,D and E. Will thi...
OneStream is not ideal for summing on the fly, CVR/CVC allow you to specify the index number of a member within a row or column so in your example it would look something like: GetDataCell(CVR(Row1,1) + CVR(Row1,2) +CVR(Row2,1) +CVR(Row2,2) + +CVR(Row2,3)):Name(TotalSum)
However this is not very dynamic.
Do create something dynamic is a lot more difficult. I have solved the problem but I'm not sure my method is best practice so I wont share here!
How about
Row1 = GetDataCell("A#A + A#B): Name("Operating income (loss)")
Row2 = GetDataCell("A#C + A#D + A#E): Name("Operating income (loss)")
I want to add Row1 and Row2 in another row called Row3 without using the member filter?
