13 Replies Latest reply on Jul 20, 2016 6:26 AM by Dario Restrepo

    Data Blending Help - suspect Dates causing issue

    Dario Restrepo

      Hi everyone,

       

      Wanted to see if someone can kindly review my workbook.  I am having trouble Data Blending two different tables to do a Travel Expense budget analysis comparing budget estimates versus Actual results

       

      In the worksheet tab called 'budget v actual (BLEND)' the values for Values_Actual are way off.  I suspect that this pertains to a blending issue regarding Dates.  In the Budget data source, a date calculation is used whereas the Actual travel expense data sources uses actual dates when the expense occurred.

       

      Any help is greatly appreciated as always!!

       

      - Dario

       

      Attached is the workbook for your review.