1 2 Previous Next 16 Replies Latest reply on Mar 2, 2016 12:10 PM by lakshminarayana.m

    Calculation based on Data Blending not working.

    lakshminarayana.m

      Please see the attached workbook.

       

      Hi,

      It has three tabs. Plans, Individual Plans and Aggregate Plans. (all filtered on plan type= Total PPlans)

       

      Pplans has Individual and Aggregate plans and so  is the reason I blended on the Aggregate ID's to see ...when Plan ID is null then show Individual and when not null showing aggregate ID's which I'm good to show in separate worksheets.

       

      But my requirement is to show all the three in one worksheet which is Plans tab in my attached workbook.

      I need to show Total PPplans  as 3864982 which is easy and I'm good but when trying to show the other two counts I'm getting 0's.

      FYI:

      Total PPLans = Pplan- Individual  Plans+Pplan- Aggregate  Plans  (How I'm identifying is based on plan_id in the secondary source)

       

      The calculations I'm using are  Pplan- Individual  Plans and    Pplan- Aggregate  Plans ( which are not working)

       

      So final output i want to show in one worksheet is :

      3864982

      1,417,233

      2,447,749

       

      Please share your thoughts.

      Thank you in advance

        1 2 Previous Next