Forum Discussion
Solved
Standard Deviation without considering 0
Good afternoon capos, I am trying to calculate the standard deviation based on the yield what happens is that it brings 0 (zeros) then the deviation comes out an absurd value I have tried to do it w...
Hi, Syndicate_Admin ;
Please try to create a measure to calculate the standard deviation.
standard deviation = STDEVX.P(ALL('Table'),DIVIDE([Volume (Tons)],[Hours Worked (Hours)]))The final output is shown below:
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You should be able to solve this by applying a report level filter Volume>0