Allow creation of formulas/functions to keep field/attribute name

Sreekumar_Analytics_Ambassador

-         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.

Avinash Krishnaram-Oracle

Hello,

This is a planned feature for OAC 2024. We will share more details on the release target as we make good progress on the development work.

Thanks

Avinash

Doug Ross

Great to hear this is being developed. Readability and not having to modify referenced calcs would be great.