Forum Discussion

rsbin's avatar
rsbin
Community Champion
6 years ago
Solved

Standard Deviation yields NaN error

Good Afternoon All & Greg_Deckler    Following up on my previous thread wherein I used the following formula to calculate Standard Deviation:   StdDev_EquipID = VAR __table = SUMMARIZE(GeneralSt...
Need Help
  • az38's avatar
    az38
    6 years ago

    rsbin 

    try

    StdDev_EquipID =
VAR __table = SUMMARIZE(FILTER(GeneralStatistics, GeneralStatistics[TotalVisits] <> 0),[Date],"__EquipID",[EquipmentIDRatio])
RETURN STDEVX.P(__table,[__EquipID])
rsbin's avatar
rsbin
Community Champion
6 years ago

edhans   Thanks kindly for the reply.  Same solution as az38     ....he just beat you to it.

 

Appreciate you chiming in and confirming solution.

 

All the Best

edhans's avatar
edhans
Community Champion
6 years ago

Hey, no problem rsbin - he was quicker with the enter key!

 

Kudos/Thumbs up are still welcome. In any event, glad your problem is resolved and your project is moving forward.