Financial Reporting Total Sum Issue

878783

Hello Experts,

I am having 2 issues in Financial report/

1. In my report I setup the row as "prompt for entity" for users. What ever the entity choose by users,

1. Need all the level 0 of that hierarchy (Not descendants). - How to do this?

2. And, Also need the sum of all the Level 0 Members ( I will insert one more for that ) - ??????

I appreciate for your help.

Thanks.

Celvin Kattookaran

In member selection select

Descendants of Prompt for dimension

Lev0, Dimension

From View select Advanced and then use AND as operator.

Selecting Multiple Members Based on Criteria and for sum add a formula row with SUM([1]) (if it is row 1)

Regards

Celvin

http://www.orahyplabs.com

878783

I have already tried, But it's not working. and when I do SUM([1]) for rows, I am doing for Column and tried SUM([A]), it's giving only first cell value. have you tried the same form your end, is it for working for you ?

Celvin Kattookaran

You said Entity is in Row and if you want the sum of all level 0 entities (according to question 1) then you should be insert a formula row not column.

Yes it works for me.

Rows:Descendants of Prompt for Measures AND System-defined member list Lev0,Measures

Columns: Children of Year

	Qtr1	Qtr2	Qtr3	Qtr4
Sales	1,998	2,358	2,612	1,972
COGS	799	942	1,044	788
Marketing	278	328	364	275
Payroll	153	159	153	153
Misc	2	1	1	2
Sum([1])	3,230	3,788	4,174	3,190

Regards

Celvin

http://www.orahyplabs.com

878783

The solution you given me resolved my issue. Thanks a lot Celvin

878783

Hi Celvin,

I have a small question.

I need to divide the cell [C,4] by 1. So, I wrote like 1/[C,4] and Eval(1/[C,4]) but still it;s working. Do you have any idea please help me ?

Thanks.

878783

Typo...

Hi Celvin,

I have a small question.

I need to divide the cell [C,4] by 1. So, I wrote like 1/[C,4] and Eval(1/[C,4]) but still it;s not working. Do you have any idea please help me ?

Thanks.

Celvin Kattookaran

Works fine for me. Question that I've is, when you are in studio can you see 4 rows and 3 columns ( then only you can use [C,4])

If that cell is a result of expansion then you'll have to do something like 1/[A(c),1(4)]

Column A is expanding to 3 or more  and Row is expanding to 4 or more rows.

Regards

Celvin

http://www.orahyplabs.com

878783

I tried this but somehow not working for me.

I am calculating Col B column

          Col A  Col B

row1  1.4      1/[row1,col A] 

row2  0.2      1/[row2,col A] 

row3   0.7      1/[row3,col A] 

row4  3.3      1/[row4,col A] 

Could you check and save my time please

Celvin Kattookaran

How about 1/[A,1]?

Regards

Celvin

http://www.orahyplabs.com