7 Replies Latest reply on Sep 13, 2017 8:25 AM by Wes Patton

    Conditional Weighted Average

    Wes Patton

      I wanted to calculate a weighted average, for example WA Current FICO Score, but only do it if the score is valid.


      If I segment the numerator and denominator, I can get it to work fine, but there has to be a way to do it in one calculation, right?


      N = if ([Curr FICO])>300 then ([Curr FICO]*[Src Outstandings]) END

      D = if ([Curr FICO])>300 then ([Src Outstandings]) END

      WA = N/D


      I really just want if Curr FICO > 300 then sum(FICO * OS) / sum(OS) in one place.