Consolidate using Elim Entries

[Jason2121]

Hello,

This is a simple question and con not figure it out myself. I am producing a Bal Sheet w/ Eliminating Entries. My Eliminations are fine, but I can not figure out the formula for the Consolidating Column. My eliminations have the negatives & positives where need be so that is why I am adding one column to the next.

I have right now the formula
{@Amount Current}+{@Eliminating.Entries}

Even whe I created the column when using Variance from previous year I used the formula
{@Amount Current}-{@Amount Prior}

Can someone explain why this formula does not work or have any tips when trying to run the Cosolidated column.

Thanks - Jason

 

[lbass]

You should always post the contents of any formulas and of any formulas nested within them. Can't help without knowing this.

-LB

 

[Jason2121]

I tooled around with Formulas and created one that does work. I called it Consolidated

I do though have another question:

When Summing to get total assets, I just used the sum function for my Consolidated fields. But I can't seem to find a formula to Summ the Total Liabilities and Equity. I tried using the same function from the Original Fomula to Sum The totals but it does not Sum correctly:

If {RV_GLSA_ROLLING_BAL.GL_YR} = {@Current Year} Then
If {@Accounts} in "4000" to "9999.999999" Then
If {@month} = 1 Then
If {@Accounts} in "4050.1" to "4055" or {@Accounts} in "6000" to "7299" or
{@Accounts} = "7310.1" or {@Accounts} in "7370" to "7511" or {@Accounts} in "7995.1" to "7995.6"
or {@Accounts} = "9999" Then
-({RV_GLSA_ROLLING_BAL.GL_PER_1_ACCUM_BAL})
Else
{RV_GLSA_ROLLING_BAL.GL_PER_1_ACCUM_BAL}

The following is an example for Total Current Liabilites:

Pre-Elim Entry Elim Entry Consolidated
Current Liabilities
Accounts Payable 779,810.62 466,712.01 313,098.61
Adv Billing & Pymts 293,832.14 (5,552.34) 288,279.80
Total Liab&Equity "Total L & E" ------- ???

If this is not enough info, please let me know
Thanks - Jason

 

[lbass]

Since I don't know what your account codes refer to I have no idea what the formula is really doing. You should also explain in what way the results are incorrect. Note that generally, when using if/then's, you should set them off with parens so that it is clear what clauses go with what. I myself would translate this into "and's" in order to keep it clear, as in:

If {RV_GLSA_ROLLING_BAL.GL_YR} = {@Current Year} and
{@Accounts} in "4000" to "9999.999999" then
(
If {@month} = 1 and
{@Accounts} in ["4050.1" to "4055","6000" to "7299", "7310.1","7370" to "7511", "7995.1" to "7995.6", "9999"] Then
-({RV_GLSA_ROLLING_BAL.GL_PER_1_ACCUM_BAL})Else
{RV_GLSA_ROLLING_BAL.GL_PER_1_ACCUM_BAL}
) else
?

-LB

 

[Jason2121]

Thanks - I got it now.