topic Re: Add calculated dimension in App Development

Add calculated dimension

stekol61 — Fri, 30 Nov 2018 13:55:40 GMT

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?

Re: Add calculated dimension

hopkinsc — Fri, 30 Nov 2018 14:02:48 GMT

Can you not hide the dimension in the presentation tab? or do you not want it there at all?

Re: Add calculated dimension

agigliotti — Fri, 30 Nov 2018 14:05:29 GMT

how is your table (dimensions and measures) and what is your actual and desired output?

Re: Add calculated dimension

stekol61 — Fri, 30 Nov 2018 14:23:25 GMT

Hi!

My table look like the enclosed picture.

The expression in my example is for the 'Cost' measure.

The dimension used is 'wor_AssignmentProfile'

Using the dimension in the table the calculation for 'Cost' is OK. Without the dimension the calculation is not OK.

I don't want to use the dimension in the table but i want the calculation for 'Cost' to be correct

Re: Add calculated dimension

agigliotti — Fri, 30 Nov 2018 14:52:40 GMT

how does the measure "Cost" looks like?

Re: Add calculated dimension

stekol61 — Fri, 30 Nov 2018 14:54:33 GMT

Like this

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

Re: Add calculated dimension

agigliotti — Fri, 30 Nov 2018 15:21:10 GMT

let's try with the below expression:
sum( Aggr( if (wor_AssignmentProfile ='Eltel - FS - SE - B2B' and wor_AssignmentProfile ='Ericsson - FS - SE - B2B',Sum([Eltel SWE])-Sum([Transtema])), Dim, wor_AssignmentProfile ) )

Re: Add calculated dimension

stekol61 — Tue, 04 Dec 2018 09:44:09 GMT

Hi!

It doesn't work.

If I select both 'Eltel - FS - SE - B2B' and'Ericsson - FS - SE - B2B' the Cost will be '0'.

Even if I select just one them the result is *0*

Re: Add calculated dimension

albert_guito — Tue, 04 Dec 2018 17:37:37 GMT

Hi,

It seems an intersection of set analysis.

Try with this:

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

Albert

Re: Add calculated dimension

stekol61 — Wed, 05 Dec 2018 12:10:55 GMT

Hi!

This expression doesn't work at all.

I receive *Error in expression' when I try to add it to the table.

Re: Add calculated dimension

albert_guito — Wed, 05 Dec 2018 14:29:20 GMT

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+

Re: Add calculated dimension

stekol61 — Wed, 05 Dec 2018 15:26:35 GMT

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 '-'