on 09-10-2014 4:34 PM
Hi Experts,
I have a dubt on a web Intelligence report about sum calc with dimensions from different queries. Let me give you an example.
Imagine we have from one query A:
And from query B:
We have City as merge dimension
And we need this result on the report:
The formula that I would writte to resolve it would be:
=Sum([Revenue] In ([City])) In ([Country])
But as we don't have the dimension Country on the query A I get 900 for all countries.
Can you help me to resolve that?,
Thank you
The solution is quite simple - use:
=forcemerge([Revenue])
Description of Forcemerge:
Includes synchronized (e.g. Merged) dimensions in measure calculations when the dimensions are not in the measure's calculation context.
HTH
NMG
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Oscar,
Just change the formula
1.variable
Sum1=Sum([Revenue]) Where([City] =[City])
2.variable
Final_Sum=If [City] =[City]) Then ([Sum1]) Else [Revenue]
Regards
Mustafa
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
But means that I will have to know all valuest to writte InList operator, what about if is coming a new one? It will be necessary to change the variable values, isn't it?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Oscar,
You can use Inlist operator for multiple vale..........
Regards
Mustafa
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.