> or < in Script

[priyarane]

Hi Community,

Is there any other to keep < or > in Script part as these are not wroking.

for ex:

if( amt_1 > amt2 ,amt_1,if( amt_1 < amt2 , amt_2)) as amt_F

the above column amt_F have 0 rows, when use the same if statement in front end side and I am getting values.

-Priya

[priyarane]

it is not correct data as per scenario... I have added some clarity data.

[sunny_talwar]

Is this not the output you want? If not, then what do you want?

Table:

LOAD Amt1,

    Amt2,

    RangeMax(Amt1, Amt2) as AmtF2

FROM

[..\..\Downloads\Dat sample (1).xlsx]

(ooxml, embedded labels, table is Sheet1);

[priyarane]

Sorry Sunny for confusion here,

let me clarify with good data and requirement

Bought   > Sold  – Use Sold

Bought   < Sold  – Use Bought

Bought   = Sold  – Use Bought or sold .

[sunny_talwar · Accepted solution]

Try with RangeMin()

RangeMin(Bought, Sold) as Final