Forum Discussion
PshemekFLK
Helper IV
5 years agoSUMX weighted average doesn't work
Hi, I can't figure out why sumx doesn't result in the correct weighted average: Formula for Funnel Speed (Months) = IF( HASONEVALUE('Funnel Data'[Opportunity Closed Mo No]), S...
PshemekFLK
Helper IV
5 years agoWhen I try to fix the brackets in this formula I still get 1.2 as Total not 2.7.
I see you've changed the first part of the formula. I thought it's the second DIVIDE part that produces a wrong result.
PshemekFLK
Helper IV
5 years agoCan anyone give it a try? I still can't get to the right result