Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi Siva,
Can you attach what you declared for variables?
vMarketFareX = ?
Regards,
Jagan.
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
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.