Nested formulas in the MDA

Related products: CS Reports & Dashboards

Getting an idea out there that may be beneficial in utilizing one calculated field inside of another calculated field. Using a percentage as a component of another calculated field, for example.





Currently, users are able to create a nested formula within the MDA, but consumption areas such as Reporting and Rules Engine will not pull any data. The ability to use one calculated measure within another calculated measure may be useful for end users in terms of presentable data granularity.





Thanks!
Josh - I would like to understand this better. Can you please take an example and present your idea?Alternatively, we can have white board conversation and update this thread. 
Our firm would use this.  Our usage data stats are very detailed and the process of having to use rules to load the data into non-calculated fields - it would save us a lot of time. 
This would be super helpful! Right now, the workaround is to use a rule to copy the calculation to a different number field that can be used in the second calculated field.

Absolutely needed ! The transition fields/transformation rules create unnecessary maintenance overheads. 


Hi, 

I will add this to the roadmap and discuss how best we can bring this function to the Horizon Analytics.