Yes, you can nest functions, just as you would in Excel. There are two ways to do this: Using the Map Panel and using the Function Bar.
Using the Map Panel
1. Select the column containing "first".
2. Select the Column Operation List and select "map". The Map Panel opens. See first screenshot below.
3. Select arithmetic operations, and the div operation.
4. Your first column is already Operand A for the map operation.Wrap $first with the operation for the subtraction, as you would in Excel... sub($first, $second). See second screenshot below.
5. Then choose $total as the second operand.
6. Finally, name your New Resultant Column Name.
7. You will see in the screenshots below that the Function Bar populates with the map function for the new column. See third screenshot below.
Using the Function Bar
1. I suspect you or I would just use the function bar naturally.
2. Select the column where you wish to add a new column for the resulting total.
3. Select the Column Operation List and then select Add A Column On the Right (or Left). See the first Function Bar screenshot below.
4. Name the Column. See the second Function Bar screenshot below.
5. In the function bar, interactively type map and add the long-form functions as you might in Excel. The function bar will autocomplete using the tab key and help you along the way to writing: =map(div(sub(first, second), total)) See the third and fourth Function Bar screenshots to see how both operations and columns autocomplete.
6. Hit Enter
Map Panel screenshot #1, Select Map Operation Based on "first" column.
Map Panel screenshot #2, Map Panel Settings (select the image to see the whole panel)
Map Panel screenshot #3, Map Operation created by the Map Panel.
Function Bar screenshot #1, adding a new column.
Function Bar screenshot #2, naming the column.
Function Bar screenshot #3, Autocompleting a Function Name.
Function Bar screenshot #4, Autocompleting the final parameter, a Column Name.
Did this answer your question?