Is there any other to keep < or > in Script part as these are not wroking.
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.
Solved! Go to Solution.
This seems to be working
Alt(Amt1, Amt2) as AmtF1,
RangeMax(Amt1, Amt2) as AmtF2
(ooxml, embedded labels, table is Sheet1);
if( amt_1 > amt2 ,amt_1, amt_2) as amt_F
Note : check field Name is it amt2 or amt_2
Your data will not help. Please provide proper data.