Formula for Seperating Co. Financials

[Jason2121]

Hello,

I am creating Financials for a Parent company that has a subsidiary. They would like two seperate columns showing the amounts for 0. Parent Company and 1. Subsidiary. This is decided based on the first number. I tried to use 0. for these accounts, but at the end of my Formula I have else {RV_GLSA_ROLLING_BAL.GL_PER_1_ACCUM_BAL}

This statement right here pulls in the Subsidiary 1. which gives me a total for the Consolidated column. The reason for the -({RV_GLSA_ROLLING_BAL.GL_PER_1_ACCUM_BAL}) is because of the Acc. Depreciation.

Does anyone have a tip on how to rewrite this formula to show the first accounts as Neg in the column and the rest to be positive by only show the amounts for company 0.

If {RV_GLSA_ROLLING_BAL.GL_YR} = {@Current Year} Then

If {@month} = 1 Then

If ({@Accounts} in "0.3100" to "0.3999" or {@Accounts} in "0.4050.1" to "0.4055" or {@Accounts} in "0.6000" to "0.7299" or
{@Accounts} = "0.7310.1" or {@Accounts} in "0.7370" to "0.7511" or {@Accounts} in "0.7995.1" to "0.7995.6"
or {@Accounts} = "0.9999") Then

-({RV_GLSA_ROLLING_BAL.GL_PER_1_ACCUM_BAL}) else

{RV_GLSA_ROLLING_BAL.GL_PER_1_ACCUM_BAL}

Thanks

Jason

 

[CoSpringsGuy]

could you show what you want your output to look like?

_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 

[Jason2121]

This is not the format of it. I am just trying to see how to do an:

If

then -({RV_GLSA_ROLLING_BAL.GL_PER_1_ACCUM_BAL})

if

then {RV_GLSA_ROLLING_BAL.GL_PER_1_ACCUM_BAL}

else

How can I do this for each month so all that needs to be done is refresh for monthly financials. I am trying to create accounte that are seperately for each company:

i.e.

Parent Subsidiary 1 Consolidated


These are the three columns I would like.

Jason