TM1 Forum

Hello,
My problem is this, Account 1000 is the only child of 2000. But because 2000 is an equity account, the value needs to be 1000*(-1).
Essentially it looks like this

Account Value
2000 -1000
1000 1000

Do I fix this problem in the rules section ? Please help!!

There's a much easier solution than rules - in Dimension Editor, right click on the '1000' element and under Element Properties, change the element weighting to -1

If the way you have written your numbers down is how they are now then you already have the weighting set to -1 but you want to get the value against acc 1000 = -1000

Two ways

1.Load your values into a element called "Ledger Values", have another element in the same dimension called "Reporting Values" where you multiply the ledger values by plus or minus 1.

or

2.Apply a plus or minus 1 multiplier to the values on the way into the system.

Only do 2 if you have don't have the space in your cube to do 1 or you can't rebuild your ledger cube. The 2nd approach has some big disadvantages, since the signage has been messed around with you won't be able to get a trial balance from the system and so won't be able to prove that your data set is correct. Also if you have a new account in your load you probably won't know what multiplier to apply.

The last piece of the puzzle is how to get the multiplier. This is usually done using a ruled a attribute using the ElIsAnc formula to decide if an element is a certain part of the chart of accounts.
HTH
Steve