Simple Sort expression correction needed

[bhavvibudagam]

Hi Experts,

Can any one please help me on this.

I have a deals dimensions containing below records.

By if match condition I have  created 3 records by using the below expression.

=if(Match(Deals,'No. 1 Top Deal','No. 3 Top Deal'), 'No13Deals',

if(Match(Deals,'No. 5 Top Deal','No. 4 Top Deal'), 'No54Deals',

if(Match(Deals,'No. 2 Top Deal'), 'No2Deals')))

But getting sort order like

No13Deals,

No2Deals

No54Deals,

Expected Sort order:

No13Deals,

No54Deals,

No2Deals

I have tried the below sort expression but getting error in expression. Please correct the expression with this logic only.

=if((Match(Deals,'No. 1 Top Deal','No. 3 Top Deal'),'No13Deals'),1,

if((Match(Deals,'No. 5 Top Deal','No. 4 Top Deal'),'No54Deals'),2,

if((Match(Deals,'No. 2 Top Deal'),'No2Deals'),3)))

Thanks in advance.

Please find the attached app.

[Anil_Babu_Samineni · Accepted solution]

Try this?

=if(Match(Deals,'No. 1 Top Deal','No. 3 Top Deal'), Dual('No13Deals',1),

if(Match(Deals,'No. 5 Top Deal','No. 4 Top Deal'), Dual('No54Deals',2),

if(Match(Deals,'No. 2 Top Deal'), Dual('No2Deals',3))))

[its_anandrjs]

One of this also

=Only( {1} if((Match(Deals,'No. 1 Top Deal','No. 3 Top Deal'),'No13Deals'),1,

if((Match(Deals,'No. 5 Top Deal','No. 4 Top Deal'),'No54Deals'),2,

if((Match(Deals,'No. 2 Top Deal'),'No2Deals'),3))) )

[its_anandrjs]

Or may this

=Only( {1}  if(Match(Deals,'No. 1 Top Deal','No. 3 Top Deal'), Dual('No13Deals',1),

if(Match(Deals,'No. 5 Top Deal','No. 4 Top Deal'), Dual('No54Deals',2),

if(Match(Deals,'No. 2 Top Deal'), Dual('No2Deals',3)))) )

[devarasu07]

Hi,

best way just use the Dual function,

=if(Match(Deals,'No. 1 Top Deal','No. 3 Top Deal'), dual('No13Deals',1),

if(Match(Deals,'No. 5 Top Deal','No. 4 Top Deal'), dual('No54Deals',2),

if(Match(Deals,'No. 2 Top Deal'), dual('No2Deals',3))))

more about dual  check this article,

Dual & Exists – Useful Functions