Formula using value from different query

[Former Member]

Hi Experts

I am having trouble to create formula for Operating (Income) Loss line as shown in below screenshot. ( Webi 4.1 SP5)

I

Operating(Income) Loss =[Var_Oper_Exp]+[Var_Depre]+[Var_Revenue]+[Var_COGS]

The above formula adds correctly only Oper_exp and Depreciation in Block 2 but add extra column in right with total amount from Block 1 (Query 1)

Could you please help here, thanks!

[amitrathi239]

Hi,

All these variables are measure variables?

Which object is merged object in both queries?

Amit

[Former Member]

Hi Amit

Yes all variable are measure variable..

Company code of both block are merged dimension.

Comp_code_block1 = Comp_code_Query1 + Comp_code_query3(dimension only)

Comp_code_block2 = Comp_code_query2 + Comp_code_query4(dimension only)

Thanks for your help!

[Former Member]

Hi,

how many queries do you have ?

Regards,

Rogerio

[Former Member]

Hi Rogerio

I have total 4 query as shown

Query 3 and 4 is only to pull Master data for Company code to make my column static irrespective whether rows have data or not.

Thanks for looking into this!

[Former Member]

Any inputs will be helpful!