1 Reply Latest reply: Jun 19, 2017 6:43 PM by Sunny Talwar RSS

    Multiplication inside Sum with Total

    Tristen Hannah

      I'm trying to create a function that is essentially:

       

      SUM(colA * colB * Total ColC)

       

      But it's returning nothing.

       

      The actual expression is a little more complicated:

       

      If(Sum(count) <> 0, Sum([Number of Tickets]),

       

      Sum([curves.curve]*[OP.tixrsrperc]*

      TOTAL {<[OP.week_ending_date] = {"$(='>=' & Date(Max({<count = {'*'}>}[OP.week_ending_date], 4)) & '<=' & Date(Max({<count = {'*'}>}[OP.week_ending_date])))"}>}count

      /

      TOTAL {<[OP.week_ending_date] = {"$(='>=' & Date(Max({<count = {'*'}>}[OP.week_ending_date], 4)) & '<=' & Date(Max({<count = {'*'}>}[OP.week_ending_date])))"}>}[curves.curve]

      )

       

      )

       

      I verified all the individual parts work as expected.  Any ideas?

        • Re: Multiplication inside Sum with Total
          Sunny Talwar

          May be this

           

          Sum(Aggr(

          Sum([curves.curve])*Sum([OP.tixrsrperc]) *

          Sum(TOTAL {<[OP.week_ending_date] = {"$(='>=' & Date(Max({<count = {'*'}>}[OP.week_ending_date], 4)) & '<=' & Date(Max({<count = {'*'}>}[OP.week_ending_date])))"}>} count)

          /

          Sum(TOTAL {<[OP.week_ending_date] = {"$(='>=' & Date(Max({<count = {'*'}>}[OP.week_ending_date], 4)) & '<=' & Date(Max({<count = {'*'}>}[OP.week_ending_date])))"}>}[curves.curve]), UniqueIdentifierField))