on 08-27-2014 11:57 AM
Dear All
Following is the scenario,I am getting the data from SAP BI in the form of BA,Profitcenter and Amount.the second query is getting data from EXCEL where the amount is related with BA and Profit center as well.
Now expected result is ,we want BA from BI and PC from both the file should joined and Total Value will be Multiplication of Both the amounts of two queries.
Hi Tushar,
In this case, you can merge both the dimensions i.e. BA and PC. And in TOTAL column, you can specify formula as below:
=If (IsNull([Amount BI]) And IsNull([Amount Excel])) Then 0 Else (If(IsNull([Amount BI])) Then [Amount Excel] Else (If (IsNull([Amount Excel])) Then [Amount BI] Else [Amount Excel] * [Amount BI]))
Don't forget to drag only merged dimension of BA and PC in the block. By default, webi will do Full Outer join on this and multiply both the key figures. Try this and let us know if you face any issues.
Sahil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Have you tried below complete condition :
=If (IsNull([Amount BI]) And IsNull([Amount Excel])) Then 0 Else (If(IsNull([Amount BI])) Then [Amount Excel] Else (If (IsNull([Amount Excel])) Then [Amount BI] Else [Amount Excel] * [Amount BI]))
If still it is not giving correct result then can you please paste your formula here.
Sahil
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
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.