Difference between revisions of "ComputeCloud Formula Examples"
From dataZoa Wiki
(→Formulas with just one input Variable:) |
(→Formulas with just one input Variable:) |
||
| Line 8: | Line 8: | ||
</tr> | </tr> | ||
<tr><td>Simple 10 Point Moving Average</td><td>Movavg(V1,10)</td></tr> | <tr><td>Simple 10 Point Moving Average</td><td>Movavg(V1,10)</td></tr> | ||
| + | <tr><td>Remove Mean</td><td>V1-Mean(V1)</td></tr> | ||
| + | <tr><td>Index to 100</td><td>Index(V1)</td></tr> | ||
| + | <tr><td>Percent Change</td><td>Index(v1)-100</td></tr> | ||
| + | <tr><td>Convert to Quarterly</td><td>SetFreq(V1, 'Quarterly', 'Avg', 'PrecAuto', 'Trim')</td></tr> | ||
</table> | </table> | ||
</div> | </div> | ||
Revision as of 11:01, 24 January 2019
Formulas with just one input Variable:
| Purpose | Formula |
| Simple 10 Point Moving Average | Movavg(V1,10) |
| Remove Mean | V1-Mean(V1) |
| Index to 100 | Index(V1) |
| Percent Change | Index(v1)-100 |
| Convert to Quarterly | SetFreq(V1, 'Quarterly', 'Avg', 'PrecAuto', 'Trim') |
