Different values presented after data being loaded!
Appreciate if reference is made to the Excel data & the data after being loaded. the total shown in excel vs P/T looks different. Can you please look in to this & inform where I have gone wrong. Is it due to the way the script was made or due to data linking error.
Yes, There are two data sets & I need to reconcile the records between two data sets & if records in one data set equal to the same record in other data set ( In rupee value) that should be ok & if one record in one data set does not match with the other data set such as (it is completely missing or amounts are different etc) such record to be found as not in order. Once this unmatched records are noted I will further see why the differences are. If I can match this two tables & get the un matched records that will be ok. Is it due to the if statement in the script or otherwise? Below is the expression used to find out matched & unmatched records
Please see whether my explanation is adequate for you to proceed!
Thanks so much for your information & now my 1st issue was resolved. But when I view the Not agreed records, it seems some agreed records too are appearing. (Agreed records refer to same cre_numbers with same value & below PT shows the agreed records when not ok dimension is viewed. Is it due to an error in the if statement written or otherwise.