4 Replies Latest reply: Feb 3, 2014 3:51 PM by Brett Devine RSS

    Set Analysis Expression Aggregation Issue

      Hey All,

       

      First of all, thank for the taking the time to view and assist. I may be overlooking something here but this is giving me a headache.

       

      Objective: I'm looking to to reflect the various departmental collections within the selection (Month(s)) time frame. e.g. Bankrutpcy/Recovery by Time.

       

      Problem: It's aggregating the departments collections throughout the entire data set (over all the Months), regardless of the {$} indication. Despite the user selecting a specific month, it reflects the the SUM throughout all of time.

       

      Here is an example formulas

       

       

      SUM({$<[Department] = {'Recovery'}>}[PRINPMT_28_1]) + SUM({$<[Department] = {'Recovery'}>} [PRINNSF_28_2])

       

       

      To calculate the total collected, We add the PRINPMT_28_1 + PRINNSF_28_2 to reconcile the payments that bounced, or transactions that were removed from books.

       

      The same formual exists in a different expression that shows how much of a particular amount was collected for a various client by the Bankruptcy department.

       

      This makes a very easy and convenient way for the user to see how much of the "SUM" came from which department.

       

      I hope I articulated this enough for everyone.

       

      Thanks,