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!
Helper VHi 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%.
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
- DanCasSan
It 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!