Skip to Content
0
Former Member
Apr 16, 2011 at 05:21 AM

Design/Formula problem

29 Views

Hi BPC Gurus,

I am making an input schedule for Revenue Planning. for which I have created the following design

Particulars--


Jan'11--


Feb'11

-


Qty---- Rate


Amt
Qty
-- Rate ----Amt

Product--


300
5
--

1500

Product1--


100-- -2 --


200

Product2--


200-- 3 --


600

Here Product is Parent, For qty, rate and Amt I have created a new dimesion called measure as userdefined type. In that for amount I have given formula [MEASURE].[Qty]*[MEASURE].[Rate]. Product are in P_acct.

At parent level my answer should be 300--


Qty, Rate
nil, Amount
--


800 (Correct)

But I am getting the following answer.

Product--


300
5
--

1500
which is wrong?

So how can I get the correct at Parent level Pls provide a solution to it.

Regards

Kumar MG