dimension if with variable

[Anonymous]

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 ?

[sunny_talwar · Accepted solution]

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