Page 1 of 1

FSG Question...How can I define different % for 5

Posted: Thu Oct 07, 2010 6:03 am
by ahsanrasheed
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

Posted: Fri Oct 08, 2010 6:21 am
by ahsanrasheed
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