Forum Discussion
Helper VCalculate the normal inverse
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!
Super UserYou formula return .98 and because you formatted at % it shows 98%. Or is it 98.
If it 98 then divide this column by 100 and use.
98 is one example value, you have lot of such values
Helper VIt is correct, my data is 0.98, as you can see in the image attached
daxCommunity Support
Hi DanCasSan ,
Based on my test, I find that it seems only work on fixed data like below =NORM.S.INV(0.9), I can't refer to column in this. You also could refer to this video and inverse-normal-cumulative-distribution (this also refer to a cell instead of column) for more details.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- DanCasSan
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!- dax
Hi DanCasSan ,
Thank you for your reply! If you'd like to, you could mark corresponding post as answer or share your solutions. That way, people who in this forum and have similar issue will benefit from it.
Thanks for your understanding and support.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.