dimension if with variable

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

i ,

I'm trying to create a calculated dimension using a variable, but I'm not getting it.

In an attachment I send a small application that intends to explain what I intend.

Put in dimension anything like:

= If (Dim1 = $ (vDisplayMaxDim1), 'A',

If (Dim1 = $ (vDisplayMinDim1), 'B', 'C'))

If i create 1 text field with the variable works fine, but in dimension if no.

some help ?

Re: dimension if with variable

sunny_talwar — Thu, 04 May 2017 23:11:10 GMT

May be look at the attached

UPDATE: For variable, I added = sign in front of the expression in the variable definition

For the other method, you need to add TOTAL

=if (Dim1=max(TOTAL Dim1),'A',

if( Dim1=min(TOTAL Dim1),'B','C'))