Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
it is not correct data as per scenario... I have added some clarity data.
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);
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 .
Try with RangeMin()
RangeMin(Bought, Sold) as Final