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
CLU
1 year agoNew Contributor III
Cube View Row Math?
Hello all,
I've written a Member Filter Builder on A#IncomeStatement.Base.Where(AccountType Contains Revenue). A second one for Expense too. I am now trying to sum those rows and cannot seem to get the math logic to render. Any advise out there - what am I missing or not considering? Columns are Entities, not row/column sharing, and the number of rows are extensive.
I've tried the following and cannot seem to get it right:
GetDataCell(CVR([TB_Rev])):Name(Total Revenue)
GetDataCell(A#IncomeStatement.Base.Where(AccountType Contains Rev):Name
Thanks in advance for your help,
1 Reply
- RobbSalzmannValued Contributor II
I think you'll need an XFBR for this. Its been requested as a feature to sum dynamic rows, but not available.:
Cube view total row | OneStream Community
Subtotal of a Cube View expansion? | OneStream Community
Related Content
- 3 years ago
- 4 years ago
- 1 year ago
- 2 years ago