> 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

[sunny_talwar]

Can you share the script for the table where you are doing this?

[sunny_talwar]

You can simplify your expression to this

RangeMax(amt_1, amt_2) as amt_F

But don't think that will resolve your 0 row issue

[priyarane]

added

[priyarane]

it gives me values but there are 3 scenarios

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

[sunny_talwar]

This seems to be working

Table:

LOAD Amt1,

    Amt2,

    Alt(Amt1, Amt2) as AmtF1,

    RangeMax(Amt1, Amt2) as AmtF2

FROM

[..\..\Downloads\Dat sample.xlsx]

(ooxml, embedded labels, table is Sheet1);

[sunny_talwar]

This should still work

RangeMax(amt_1, amt_2) as amt_F

[PrashantSangle]

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

will work

Note : check field Name is it amt2 or amt_2

Your data will not help. Please provide proper data.

Regards

[PrashantSangle]

In 3rd scenario

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

Note : check field Name is it amt2 or amt_2

Regards,

[priyarane]

names are fine, I just typed we can correct, take only content pls.