Forum Discussion

KatkaS's avatar
KatkaS
Icon for Post Patron rankPost Patron
6 years ago
Solved

Vlookup and calculation

Hello, I'm struggling with following: I have two tables and I need to calculate the difference between amounts in two columns (one in each table), based on the FAM line (4+ digit number).   Coul...
Need Help
Icey's avatar
Icey
Icon for Community Support rankCommunity Support
6 years ago

Hi KatkaS ,

 

If you don't mind, please give me some data sample.


Best Regards
Icey

KatkaS's avatar
KatkaS
Icon for Post Patron rankPost Patron
6 years ago

Hello Icey!

 

Thank you for your time!

I have two tables and I have to find out that when I deduct the amounts from each other, if I get a zero difference or there is a difference (and how much). The common thing it the Fam line (it is an accounting line) and Company abbreviation. I also need to be able to filter based on Period (I usually have Slicer for this).

The outcome should be Matrix: Company / FAM line / Difference...