Hello All,
I am a new user. I have a question. Attached file has some ratio by state(tab 1) and Name, Income type and Amount (tab 2). How can I divide the income to each person by income type using the state ratio? I know it is a broad question. However I am trying to get some idea to get started with it?
Solved! Go to Solution.
Hi @RN02,
Yes. I am trying to distribute each persona's income to every single state based on ratio.
Rahat
Okay, got it @imrahu01
Based on your requirements, @AbhilashR has already offered a robust solution!
Credit @AbhilashR
Cheers!
That is exactly what I am looking for. THANK YOU SO MUCH.