Hi
Let me explain the scenario
I have Row A with USD 300.-
I have Row B with USD 555.-
And
I have
Col 1 where allocation % should be 10%
Col 2 where allocation % should be 23%
Col 3 Where allocation % should be 27%
Col 4 where allocation % should be 20%
Col 5 where allocation % should be 20%
I want to allocate/ distribute USD 300.- according to above %(s) in Col 1,2, 3, 4, 5
and
I want to allocate/ distribute USD 500.- according to above %(s) in Col 1,2, 3, 4, 5
How can I do that...? Is this functionality is available in FGS. I am working in R12.
regards
Ahsan
FSG Question...How can I define different % for 5
-
- Posts: 18
- Joined: Fri Aug 13, 2010 1:07 am
- Location: Pakistan
- Contact:
-
- Posts: 18
- Joined: Fri Aug 13, 2010 1:07 am
- Location: Pakistan
- Contact:
I have a little tweak in situation...
Lets suppose I have following
:::::::::::::::::::::::: Col 1:::::::::::::::::::::Col 2::::::::::::::::::: Col 3
Row A USD 500 | 10% of USD 500 | 20% of USD 500 | 70% of USD 500
Row B USD 200 | 15% of USD 500 | 30% of USD 500 | 65% of USD 500
How can I establish s formula for the above situation as per my understanding, if Row has 10%, that 10% would be applicable to whole line of Row A for all columns in Row A
Or if define a 10% in Column 1 that 10% would be applicable to all rows falling with Col 1.
Can I request your help for the above sitiation...?
regards
Ahsan
Lets suppose I have following
:::::::::::::::::::::::: Col 1:::::::::::::::::::::Col 2::::::::::::::::::: Col 3
Row A USD 500 | 10% of USD 500 | 20% of USD 500 | 70% of USD 500
Row B USD 200 | 15% of USD 500 | 30% of USD 500 | 65% of USD 500
How can I establish s formula for the above situation as per my understanding, if Row has 10%, that 10% would be applicable to whole line of Row A for all columns in Row A
Or if define a 10% in Column 1 that 10% would be applicable to all rows falling with Col 1.
Can I request your help for the above sitiation...?
regards
Ahsan
Who is online
Users browsing this forum: No registered users and 0 guests