5 Replies Latest reply: May 22, 2015 3:47 PM by Jonas Melo RSS

    Divide the sum of 2 number fields

      Hello,

      I need to divide the sum of 2 number fields.  I've tried this:

       

      ==Sum({$<[Date] = {'>=$(vMaxDateMinus6)'}, RecordType = {'Table Name'}>}[Weighted_Avg_Spread])

      /

      Sum({$<[Date] = {'>=$(vMaxDateMinus6)'}, RecordType = {'Table Name'}>}[Amount])

       

      I need this to come up as a percentage.  What I'm really trying to get is the Weighted Average.

       

      Please help.