4 Replies Latest reply: Nov 15, 2016 10:04 PM by Supriya R RSS

    Calculating earnings according to counts.

    Supriya R

      I am getting counts of invitations by Client specific,

       

      count({$<MonthPeriod={"$(=Date(MonthStart(weekend(Max(CanonicalDate))),'MMM-YY'))"}, DateType= {'invitation'},

      client_id={'234'}>} invitation_id)

       

      Now i need to calculate earnings for that so for that my requirement will be

       

      like for first 1-3000 invitations = charges a flat fee of $2800,the next 3001-10000 invitations is at rate of $1.50 per invitation,the next 10,001-15000 invitations = is at rate of $1.35 per invitation,the next 15001 and over = is at rate of  $1.25 per invitation.

       

      How could i calculate this.Please help me on this.