Skip to Content
0
Former Member
Feb 25, 2009 at 12:04 AM

Percentage calculation on query designer (7.0)

165 Views

Hi experts,

I´m new on Query designer (7.0) and I´m trying to do a finnancial report, so for the lines I create and structure using G/L accounts and in the columns I got the amount for each level in my structure for a month. Now I´m trying to create an Integration percentage, it specifies how high the percentage in a level is in relation to next higher level but so far I couldn't make it...

My report must seem like this:

Structure.............................Amount ...... Int %

*****************************************************************

1. Assets................................1000 ....... 100%

1.1 Current assets.................... 600 ....... 60% -> (600/1000)*100

- Cash............................. 300 ........ 50% -> (300/600)*100

- Inventories..................... 300 ........ 50% -> (300/600)*100

1.2 Long-term assets................ 400 ....... 40% -> (400/1000)*100

- Property, plant and eq..... 150 ....... 37.5% -> (150/400)*100

- Investment property......... 150 ....... 37.5% -> (150/400)*100

- Intangible assets..............100 ....... 25% -> (100/400)*100

I try to use each Percentage calculation options (%, %A, %CT,%GT, %RT) but it didn't work. Can anyone help me in creating a formula to get this percentage?

Thanks