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!

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Document say it takes Probability. means value between 0 and 1. What values you are passing

 

NORM.S.INV(Probability)

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

Hi amitchandak , thanks for answering my question. I have a % service level column and it contains variant information such as 98%, 96%, 94%, 92% and 90%.