✅ Motivation behind using nested functions

[tsmith]

I saw the following in Xcalar online help

map(mult(mult(mult(div(sub(AskPrice_float, BidPrice_float), AskPrice_float),100), div(add(BidSize_float,AskSize_float),2)),100000))

Is it faster to execute nested functions? Also, is this the only way to do A+B+C in a single step, where A, B and C are columns?

[jennyyan]

Hi Tiffany,

That's correct. The function bar is built for more complex operations beyond what our basic operation panels provide.

Thanks!
Jenny

[tsmith]

I see, thanks! But what about my second question?

Also, is this the only way to do A+B+C in a single step, where A, B and C are columns?

[jennyyan]

You can nest the second addition in the map panel. For example, in operand 2 type add($B, $C)

[dshetty]