PrvYrAmt--
PrvYrQty
-- AvgPrice----
CurYrQty
--CurYrAmt
-
(PrvYrAmt----
(CurYrQty *
-
/ PrvYrQty)----
Prv Yr AvgPrice)
150 -
10 -
$15--
225
100 -
20 -
$5 -
10----
50
Total -
$10 -
25----
250(sum 275)
When I try to create a Formula with CurYrAmt I need to use $275 and not $250.
I tried the SUMCT and SUMCT functions, but it does not use the summarized data $275 as it is a "display data" function. It uses 250 instead.
Does anyone have any ideas to force BEX to use the Summed data 275 in the calculation?
Thanks
Edited by: Rajesh Francis on Nov 21, 2008 9:44 PM
Edited by: Rajesh Francis on Nov 21, 2008 9:45 PM