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

    Divide the sum of 2 number fields


      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.