4 Replies Latest reply on May 10, 2018 4:08 AM by Shanmukh Kamarthi

    Count of transactions and all others

    Shanmukh Kamarthi

      Hello,

       

      Kindly assist to get count of transactions for Top 10 and others. I have arrived at total sum of top 10 and others but unable to do count of the same.

       

      (Working)This is for total sum:

      IF ([In top n?]) THEN

          SUM([2018 Amount])

      ELSEIF ([Show All Sub LOB]) THEN

          SUM([2018 Amount])

      ELSEIF ([Others?]) then

          WINDOW_SUM(SUM([2018 Amount]), 0, LAST())

      ELSE

          NULL

      END

       

       

      (Not Working) for count:

      IF ([In top n?]) THEN                                           

          COUNT([Voucher ID])

      ELSEIF ([Show All Sub LOB]) THEN

          COUNT([Voucher ID])

      ELSEIF ([Others?]) then

          WINDOW_COUNT(COUNT([Voucher ID]), 0, LAST())

      ELSE

          NULL

      END

       

      Calculations used:

      In top n?:

      [Top 5] <= [Top x choice]

           *Top 5 = Index()

           *Top X Choice = Parameter

       

      Show All Sub LOB:

           Parameter (Boolean)

       

      Others?:

           [Top 5] = [Top x choice] + 1