Version: 4.2.1 +
In this tutorial we'll show you how to work with tables in Futurama. We will create some tables, and show some table-specific formulas and features.
- The Futurama Editor must be installed.
- Completing the tutorial Creating formulas with Futurama first, is recommended.
This tutorial is independent of the application-type. Therefore we will only work with the calculations-file. In this way, we are creating a calculation-file that can be used for different types of applications, and we don't have to build calculations more than once.
This means, this tutorial is used in all three series.
In this tutorial we want to add a service fee to the interest rate.
Safe2Save has a table with two different service fees, based on the starting amount:
|Starting amount||Service Fee|
|0 - 20.000 ||0.2% |
|20.000 and more ||0.1% |
For deriving the appropriate service fee, we will first add a data-table to the calculation-file. Based on the cash balance, the service fee is looked up in the table. The service fee is then included in the future savings formula. This results in the following formula:
Future Savings:= Cash Balance*(1+Interest-ServiceFee)^Years
At the end of the turorial, we will test our new future savings formula, to see if it works as expected. By doing so, we are also showing some more features of tables, f.i. including tables as input for arguments.