creating a new field

[hamza99a]

Hello all,

I have created a table that shows Account Type, the region, and the balance amount for the day. I now want to show percentage of my yearly goal for each region and each account type. I have created an excel file that has the same dimension names, yet when I add them in and try to do a calculation with the goal, it seems that it appears null. If anyone knows how to help Id greatly appreciate it.

Thanks,

Hamza

[hamza99a]

i keep getting an error and it crashes when I run the code.

[groveliam]

Gabor!!!! My duuude you saved me. Idk what that guys problem is, but your answer is definitely perfect for my problem! undergrinder‌

[hamza99a]

Gabor, I am sorry you were actually right, however one of my colleagues wrote a horrendous script that was preventing the join from working. #workingwithbadqvdfiles

[undergrinder]

I'm happy, that your problem is solved

The things can be tricky