Trace:

set_column_formula

This shows you the differences between two versions of the page.

Both sides previous revision Previous revision Next revision | Previous revision | ||

set_column_formula [Mon Nov 8 00:39:29 2010] Alexander |
set_column_formula [Mon Jan 18 17:35:05 2021] (current) Alexander |
||
---|---|---|---|

Line 1: | Line 1: | ||

====== Setting Column Formula ====== | ====== Setting Column Formula ====== | ||

- | Use Table -> Set Column Formula menu item to open column formula dialog window. | + | === There are two ways to set formula for column evaluation: === |

- | See [[formula|formula syntax]]. | + | 1. Select column and write formula in formula string. |

- | {{: | + | {{: |

+ | | ||

+ | 2. Use '' | ||

+ | | ||

+ | {{:?nolink| Set column formula dialog}} | ||

===== Row Index ===== | ===== Row Index ===== | ||

Line 18: | Line 22: | ||

===== Using Table Data ===== | ===== Using Table Data ===== | ||

There are two functions to obtain current table cell values in formula: | There are two functions to obtain current table cell values in formula: | ||

- | * '' | + | * ''''A'' in the current (i-th) row. Equivalent to '' |

* '' | * '' | ||

Line 27: | Line 31: | ||

===== Auto Recalculation on Data Change ===== | ===== Auto Recalculation on Data Change ===== | ||

- | MagicPlot can automatically recalculate formula when data in used columns is changed. Set '' | + | MagicPlot can automatically recalculate formula when data in used columns are changed. Set '' |

== Example == | == Example == | ||

- | * Set formula ''ex.: integral, derivative of other column). | + | * Set formula ''e.g. integral, derivative of other column). |

===== Formula Menu in Column Context Menu ===== | ===== Formula Menu in Column Context Menu ===== | ||

You can edit column formula and change auto recalculation mode from column context menu or menu '' | You can edit column formula and change auto recalculation mode from column context menu or menu '' | ||

- | {{: | ||

- | ===== What is "at row #" Warning? ===== | + | {{: |

+ | | ||

+ | ===== “Argument is out of range at row #” Warning ===== | ||

Some mathematical functions can be defined only on a certain interval. For example, square root ('' | Some mathematical functions can be defined only on a certain interval. For example, square root ('' | ||

The calculations are not terminated if NaN value occurs in some row(s). | The calculations are not terminated if NaN value occurs in some row(s). | ||

- | In some cases you may want to check if a ''Not-a-Number returned at row #//". This row number is the first row in which '' | + | In some cases you may want to check if a ''Argument is out of range at row #//". This row number is the **first** row in which '' |

===== See Also ===== | ===== See Also ===== | ||

- | * [[formula|Formula syntax]] | + | * [[expressions]] |

set_column_formula.1289165969.txt.gz · Last modified: Sun Nov 8 12:20:34 2015 (external edit)

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International