Forum Discussion

DanCasSan's avatar
DanCasSan
Icon for Helper V rankHelper V
6 years ago
Solved

Calculate the normal inverse

Hello community!   Again here bothering you with my queries.   I'm trying to calculate the normal inverse, but, I'm getting error. I have tried to do it as a measure and column and in both it thr...
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • DanCasSan's avatar
    DanCasSan
    6 years ago

    Correct, apparently only fixed values ​​are allowed, not columns or tables.

    But, thanks to your comment I was able to implement an IF to evaluate the field of percentages.
    Thank you!

IBIANALYST's avatar
IBIANALYST
Frequent Visitor
3 years ago

Actually I just found, if you use the formula with SUMX it can work with a measure or a column not only a fixed value.|

Here is the formula I used
Sigma = CALCULATE(sumx([table], -NORM.S.INV([measure])+1.5))