Add calculated dimension

[stekol61]

Hi!

I have created a simple table and added a measure with this calculation:

If (wor_AssignmentProfile ='Eltel - FS - SE - B2B' and wor_AssignmentProfile ='Ericsson - FS - SE - B2B',Sum([Eltel SWE])-Sum([Transtema]))

If I include the dimension (wor_AssignmentProfile ) in the table the result is OK.

Excluding the dimension in the table the result is not OK.

I don't want to use the dimension in the table. Can this be handled in the calculation or in some other way?

[albert_guito]

Sorry, there was a mistake in the code.

Etel SWE has a parentheses at the beginig.

This is the right code:

=Sum({<wor_AssignmentProfile ={'Eltel - FS - SE - B2B'}>+<wor_AssignmentProfile ={'Ericsson - FS - SE - B2B'}>} [Eltel SWE]-[Transtema])

Ag+

[stekol61]

Hi!

I receive '0' if I select both 'Eltel - FS - SE - B2B' and  'Ericsson - FS - SE - B2B'.

Should not [Eltel SWE]-[Transtema] be a '+' intead of '-'