制作新专栏的公式

[#1]

我有一个包含四列的表，我正在尝试根据可用列创建一个新列。这是我的脚本：

dtq = current data table();
a = dtq << New Column( "E",
 Formula(
  If(
   Is Missing( :A ) & Is Missing( :B ), Abs( :C ),
   Is Missing( :A ), Abs( :C / (:B - :D) ) ,
   Is Missing( :B ), Abs( :C / (:D - :A) ),
   //If !Is Missing( :A ) & !IsMissing( :B ), 
   //then do Abs( :C / (:B - :D) ) and Abs( :C / (:D - :A) ) and choose the gretaer value out of the two. 
  )
 )
);

前三个条件有效，但A和B中存在值的条件是我无法解决的问题。如何让我的脚本计算2个公式并将更大的值添加到表中的列中？感谢您的任何帮助。

[#2 · Accepted solution]

你想要的 MAX（） 功能。

dtq = Current Data Table();
a = dtq << New Column( "E",
 Formula(
  If(
   Is Missing( :A ) & Is Missing( :B ), Abs( :C ),
   Is Missing( :A ), Abs( :C / (:B - :D) ),
   Is Missing( :B ), Abs( :C / (:D - :A) ),
   !Is Missing( :A ) & !Is Missing( :B ),
    Max( Abs( :C / (:B - :D) ), Abs( :C / (:D - :A) ) )
  )
 )
);

[#3 · Accepted solution]

dtq = current data table();
a = dtq << New Column( "E",
 Formula(
  If(
   Is Missing( :A ) & Is Missing( :B ), Abs( :C ),
   Is Missing( :A ), Abs( :C / (:B - :D) ) ,
   Is Missing( :B ), Abs( :C / (:D - :A) ),
   Max(Abs( :C / (:B - :D) ) ,Abs( :C / (:D - :A) ) )
  )
 )
);