- Universal/Platform-wide
Allow creation of formulas/functions to keep field/attribute name
Example:
· Formula 1 = (Plan-Actual)
· Formula 2 = (Formula 1/Plan)
Instead of the platform converting ‘Formula 1’ back into raw code, allow the code to be kept as an attribute
This would allow for
1) ease of reading function
2) allows formula 2 to automatically update if changes are made for formula 1
Formula 1:
Formula 2:
Double-clicking/bringing int ‘MTD Actuals’ custom formula/function results in it being rewritten as SQL code.
If user wants to change/update ‘MTD Actuals’ function, those changes will not carry over to ‘MTD Variance’ formula/function, as the tool has “hard-coded” the SQL code, instead of allowing it to be referenced back to the ‘MTD Actuals’ formula/function. Depending on the volume of custom formula/functions in any given workbook, this could cause oversight of updating all applicable formula/functions or make it a tedious and burdensome task.
