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.