Forum Discussion

jhimelic's avatar
jhimelic
Frequent Visitor
6 years ago
Solved

norm.inv

i have 8760 data for multiple units for multiple variables extending across multiple years.    I am trying to calculate the p50, p5 and the p95 for a particular unit (e.g. unit_1), a particular var...
Need Help
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi jhimelic ,

     

    You may try to create "norm.inv(.05,avg_re, stdev_re) "  using a measure instead of calculated column.

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
6 years ago

Hi jhimelic ,

 

You may try to create "norm.inv(.05,avg_re, stdev_re) "  using a measure instead of calculated column.

 

Best Regards,

Amy 

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.