SOLVED
Dividing income based on ratio
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
imrahu01
8 - Asteroid
‎06-04-2020
01:21 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Labels:
- Labels:
- Developer
- Developer Tools
- Workflow
5 REPLIES 5
RobertOdera
13 - Pulsar
‎06-04-2020
01:40 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎06-04-2020
01:46 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @RN02,
Yes. I am trying to distribute each persona's income to every single state based on ratio.
Rahat
AbhilashR
15 - Aurora
‎06-04-2020
01:48 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
RobertOdera
13 - Pulsar
‎06-04-2020
01:50 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Okay, got it @imrahu01
Based on your requirements, @AbhilashR has already offered a robust solution!
Credit @AbhilashR
Cheers!
‎06-04-2020
02:03 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
That is exactly what I am looking for. THANK YOU SO MUCH.