Create Beastmode using another Beastmode
The functionality to use one beastmode calculation within another by referencing just the column name would be very useful.
Currently the options include creating an SQL query, creating a convoluted beastmode, or double clicking on an exisiting beastmode and pasting the formulas from the existing beastmode in, and having to go back and manually update that every time the original beastmode changes.
An example of where this is valuable [apart from almost everywhere!] is as follows:
I need to calculate `Net Revenue` = `Gross Revenue` - `Commission` - `Fees`
- `Gross Revenue` is a separate beast mode which has some complicated cases based on what 'type' of transaction has occurred. E.g. When the transaction is with 'stark industries' and it's a 'saturday' then $100, else $80. [ with at least 30 different cases]
- `Commission` is a separate beast mode which has different %ages of gross revenue based on what 'type' of transaction has occurred. E.g. 1.5% of Gross Revenue when the deposit is below $200, and 2% of Gross Revenue when the deposit is $200+.
- `Fees` is a flat number per transaction [which is achieved through beastmode, but could be achieved through ETL/SQL].
- Finally, `Net Revenue` is a simple calculation = `Gross Revenue` - `Commission` - `Fees`
HOWEVER, since `Gross Revenue`, `Commission`, `Fees` are all individual [and complicated!] beastmodes, Net Revenue becomes far too complicated to achieve if each set of cases must be pasted into one 'super' beastmode.
Please, please, please add the functionality to reference beastmodes within each other to avoid overly complicated SQL queries and beastmodes.