Skip to Main Content
Jedox Ideas

Let us know how we can make Jedox even better!

Status Not Planned
Workspace Jedox Platform
Categories In-Memory DB
Created by Guest
Created on Dec 27, 2021

Add NORM.S.DIST and NORM.S.INV to Cube Rule Functions

Please add the NORM.S.DIST and NORM.S.INV spreadsheet functions to the Supported Functions for (Cube) Rules. Especially in the context of the new AI capabilities, the first function is very powerful in being able to convert any normalized standard deviation (Z-score) to a probability %, and the other function is to do the inverse of that conversion. Both of these cannot be replicated with more complex calculations in cube rules, since they normally require integral calculus to derive.

I also posted a suggested idea here (almost 2 yrs. ago) to replicate other statistical functions in cube rules, which should be much easier to develop now that global subsets can finally be used in cube rules. While I have been waiting for this new functionality, I was able to replicate the calculation of several key statistics in rules (like variances and standard deviations) even without these statistical functions. By contrast, I have found no cube rule workaround for the NORM.S.DIST and NORM.S.INV functions that already exist in both Excel and Jedox Spreadsheet functions.

I imagine that it should be a fairly simple matter to copy the value conversion code that you already have from these two Jedox Spreadsheet functions to make this single value conversion in cube rules, so please try to do so soon. Key Jedox model functionality that we have been building is waiting on such functions to become available. That said, if anyone has an idea for a cube rule woraround for these valuable functions in the meantime, I would like to hear it.

    Mar 28, 2024

    Thanks for the idea. This feature has been evaluated by us, however it doesn't align with our Roadmap therefore we will not implement it at this time.