How to make data in Ascending order?

[siva_boggarapu]

Hello Everyone,

Col1	Col2	Col3	Col4	col5	col7	col7
100?	120?	160?	100	-	120	160
180?	220?	230?	230	180	190	220
189?	200?	240?	189	200	240	250

I have one strght table like above. I have data only Col4,Col5,col6 and col7. Here My question is I have to fill this data based on selection of these four fileds. I need to fill Col1,col2, col3 in Ascending   order?

How it is possible?

Best,

Siva.

[jagan]

Hi Siva,

Can you attach what you declared for variables?

vMarketFareX = ?

Regards,

Jagan.

[siva_boggarapu]

Hi Jagan,

1)RangeMin($(vMarketFare1),$(vMarketFare2),$(vMarketFare3),$(vMarketFare4),$(vMarketFare5),$(vMarketFare6))--1st Expression

2)RangeMin(If(MKT1 = $(vMarketFare2), Null(), $(vMarketFare2)), If(MKT1 = $(vMarketFare3), Null(), $(vMarketFare3)), If(MKT1 = $(vMarketFare4), Null(), $(vMarketFare4)), If(MKT1 = $(vMarketFare5), Null(), $(vMarketFare5)),If(MKT1 = $(vMarketFare6), Null(), $(vMarketFare6)))--2nd expression

3)

RangeMin(

          If(Match($(vMarket1), MKT1, MKT2), Null(), $(vMarket1)),

          If(Match($(vMarket2), MKT1, MKT2), Null(), $(vMarket2)),

          If(Match($(vMarket3), MKT1, MKT2), Null(), $(vMarket3)),

          If(Match($(vMarket4), MKT1, MKT2), Null(), $(vMarket4)),

          If(Match($(vMarket5), MKT1, MKT2), Null(), $(vMarket5)),

          If(Match($(vMarket6), MKT1, MKT2), Null(), $(vMarket6))

          )-- 3rd expression

Best,

Siva

[jagan · Accepted solution]

Hi Siva,

Try like this, hope it works

RangeMin(

          If(($(vMarket1) = MKT1 OR $(vMarket1) = MKT2), Null(), $(vMarket1)),

          If(($(vMarket2) = MKT1 OR $(vMarket2) = MKT2), Null(), $(vMarket2)),

          If(($(vMarket3) = MKT1 OR $(vMarket3) = MKT2), Null(), $(vMarket3)),

          If(($(vMarket4) = MKT1 OR $(vMarket4) = MKT2), Null(), $(vMarket4)),

          If(($(vMarket5) = MKT1 OR $(vMarket5) = MKT2), Null(), $(vMarket5)),

          If(($(vMarket6) = MKT1 OR $(vMarket6) = MKT2), Null(), $(vMarket6))

          )

Regards,

Jagan.