Forum Discussion

Archana's avatar
Archana
New Contributor II
10 days ago

Cube View Groups - Forms

Hi Everyone, I'm designing a form where I display accounts in rows and columns header like Beg Bal, End Bal, Variance, etc. In the rows, I've configured a member filter as follows, which pulls al...
Consolidation
  • Pete's avatar
    Pete
    10 days ago

    You may want to try putting in that "GetDataCell(CVC([Endbal]) + CVC([BegBalAdj]) - CVC([Begbal]) - CVC([Additions]) + CVC([Amortization_or_Expense]) + CVC([MAAquisition])):Name(Variance must be 0)" in the Column Overrides on the "Tot" row.

    You will need to indicate the Column Range as RFCheck and then put the formula in the member filter. 

Pete's avatar
Pete
New Contributor III

You could also just do a GetDataCell(A#PREPAY-A#150123):Name(Total: Prepaid RF, net). By doing this you would lose the ability to drill down, but all of your details are in the rows above as well.

 If you're going to use this time and time again, then I would definitely go down the route of an alternate hierarchy so you could just call that A#PREPAYX like T_Kress mentioned. 

Archana's avatar
Archana
New Contributor II
10 days ago

Thanks for your response! I've tried using GetDataCell(A#PREPAY-A#150123), and it works as expected for BegBal, but not throughout. FYI, The RFCheck (i.e., Variance must be 0) column uses the following formula:

GetDataCell(CVC([Endbal]) + CVC([BegBalAdj]) - CVC([Begbal]) - CVC([Additions]) + CVC([Amortization_or_Expense]) + CVC([MAAquisition])):Name(Variance must be 0)

Do I need to do any changes to the properties?

 

  • Pete's avatar
    Pete
    New Contributor III
    10 days ago

    You may want to try putting in that "GetDataCell(CVC([Endbal]) + CVC([BegBalAdj]) - CVC([Begbal]) - CVC([Additions]) + CVC([Amortization_or_Expense]) + CVC([MAAquisition])):Name(Variance must be 0)" in the Column Overrides on the "Tot" row.

    You will need to indicate the Column Range as RFCheck and then put the formula in the member filter. 

    • Archana's avatar
      Archana
      New Contributor II
      10 days ago

      This works well. Thanks!