IF then in a table dimension

[joshrussin]

this is my set expression for my dimension in a table.

=If (Assigned_To_QM = 'Alpha', Assigned_To_QM,

        If (Assigned_To_QM = 'Bravo', Assigned_To_QM,

        If (Assigned_To_QM = 'Charlie', Assigned_To_QM,

        If (Assigned_To_QM = 'Delta', Assigned_To_QM))))

I am trying to make an Alpha_1 and an Alpha_2.

I want Alpha_1 to be when Area_QM -= 'yellow' or 'green'

and Alpha_2 to be when Area_QM = 'yellow' or 'green'

If (Assigned_To_QM = 'Alpha', 'Alpha_1',

     If (Assigned_To_QM = 'Alpha', 'Alpha_2'))

Any help?

[joshrussin]

=If

(Assigned_To_QM = 'Alpha_2'

    AND

     (Area_QM = 'yellow'

     or

     Area_QM = 'green')

, Assigned_To_QM)

This shows no result.

[ahaahaaha]

Hi,

May be like this

If

(Assigned_To_QM = 'Alpha',

If(

Area_QM = 'yellow'

     or

     Area_QM = 'green',

Alpha_2,

Alpha_1

))

Regards,

Andrey

[joshrussin]

The result i get from this is a table that shows the correct data that is supposed to be for Alpha_2, but is labeled Alpha_1. Then the second row shows a '-' with the total of the rest of the data

[sasiparupudi1]

May be Like this?

=If (Assigned_To_QM = 'Alpha' and Match(Area_QM,'yellow','green'), 'Alpha_1',

     If (Assigned_To_QM = 'Alpha' and (Match(Area_QM,'yellow','green')=0), 'Alpha_2'))

[joshrussin]

This just gives the row 'Alpha_2'