Question Re: Merged dimension calculation problem in Technology Q&A

Merged dimension calculation problem

ju_mia — Tue, 01 Dec 2020 16:02:46 GMT

Hello I have a merged dimension called "Proj.code project" (2nd line of the table)

I want to add up each "Item Code Fact." (1st column left) f

or any project code I want to get the table found on the right.

However the second column from the left is a merged dimension and I think this is problematic in my formulas

Re: Merged dimension calculation problem

ayman_salem — Tue, 01 Dec 2020 16:19:43 GMT

Your explanation of the problem you are having isn't clear enough to give you a possible correct answer. Can you explain it much better?

Re: Merged dimension calculation problem

ju_mia — Tue, 01 Dec 2020 17:02:27 GMT

I want to have only the table on the right, that is to say the column Fact.Code heading and the sum of effective proj.

My issue is the following : I have the left table with 4 columns:

Icode factor Project (column 1)
Project code (merged dimension) ==> Column 2
Proj.Effectif (Column 3)

I wish to have the sum of the Effective Project for each Item Code Factor

Example: For the item code = 2, the sum of the effective projects is equal to 1000

So I tried the following formula: Sum [(Effective Project)] ForAll([Item Code Factor])

but it gives me the result 1,050 on all the rows of the table.

I don't know if I was clear ?

Re: Merged dimension calculation problem

ayman_salem — Tue, 01 Dec 2020 17:27:40 GMT

If I understand you correctly, then you should use ForEach([Item Code Factor]).

Re: Merged dimension calculation problem

ju_mia — Tue, 01 Dec 2020 17:50:16 GMT

I don't know at all what to use. I think I don't express myself well To put it simply, I want to have the sum of the effective projects by Fact.Code heading So for the Fact.Code heading = 2 I must get 1000 For the Fact.Code = 69 I must get 0

Re: Merged dimension calculation problem

ayman_salem — Tue, 01 Dec 2020 18:49:14 GMT

Can you share a screenshot for the sample data of the two queries?