2 Replies Latest reply on Mar 1, 2016 3:16 PM by lakshminarayana.m

    How to create a caclulation when data blending two data sources

    lakshminarayana.m

      Hi,

      I'm trying to create a calculation based on columns coming from two sources. So I'm doing data blending.

       

      if [PLANTYPE]='Total PPlans' and isnull(ATTR([Aggregate ID's].[PLAN_ID])) then sum([Value]) else 0 end   ( throwing me an error..saying can't mix aggregate and non- aggregate) and then I 've changed the calculation to

      if attr([PLANTYPE])='Total PPlans' and isnull(ATTR([Aggregate ID's].[PLAN_ID])) then sum([Value]) else 0 end  ( It's valid but giving me zeroes)

       

      NOTE:

      Plan type and Code are from Primary source

      Plan ID from secondary source...and blended on Primary source.code=secondary source.Plan ID

       

      If needed more details please let me know.

       

      Thank you for your help in advance.

        • 2. Re: How to create a caclulation when data blending two data sources
          lakshminarayana.m

          Please see the attached workbook.

           

          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