Dividing income based on ratio

[imrahu01]

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?

[RobertOdera]

Hi, @imrahu01 

Is your hypothetical if each persona (Name) worked in every State?

Cheers!

[imrahu01]

Hi @RN02,

Yes. I am trying to distribute each persona's income to every single state based on ratio.

Rahat

[AbhilashR · Accepted solution]

Hi @imrahu01, is this what you are looking to achieve?

[RobertOdera]

Okay, got it @imrahu01 

Based on your requirements, @AbhilashR  has already offered a robust solution!

Credit @AbhilashR 

Cheers!

[imrahu01]

That is exactly what I am looking for. THANK YOU SO MUCH.